Exporting Long time-phased data to Excel

Hello Ronald,



I made the first same assumption as well.



the main reason is because if you happen to open up an old excel file, excel 2007 is smart to know. to work in COMPATIABLE MODE ,,, which is only 256 columns.





Info One:

=================

1. Launch Excel 2007

2. Click file new (so you get a brand new book)

3. and check if you get the same as me Ronald.





Info Two: from Microsoft

=================

http://www.google.com/search?q=excel+2007+max+column&rls=com.microsoft:…



http://msdn2.microsoft.com/en-us/library/aa730921.aspx





Kind Regards,



Vu Dang



Kind Regards,

Vu,



MY Office 2007 Excel is limited to 256 columns, making the last column "IV". Excel has had a limit of 256 columns ever since it was introduced.

Hi,



solution 1:

--------------

office 2007 can handle more than 1440 columns.





solution 2:

--------------

1. do your export in 3 files,

2. file 1 is for first year

3. file 2 is for second year and so on...

4. then have 1 master excel file that reference those 3.



Note:

* You can use a batch report to export it all together at once etc....







Kind Regards,



Vu Dang