Exporting Long time-phased data to Excel
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
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