View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default 2003 to 2007 Excel File

First, XL 03 can only show 255 columns, not 280.

Second, are you sure that the document you open XL 07 is a .xls file? You
may have inadvertently saved a second copy of your document as an XL 07 file
and opened that in XL 07. If you create a document in XL 07 and save it as a
..xls file (i.e., the file format for XL versions earlier than XL 07) you
cannot use XL07-specific features, such as 16000+ columns and 1 million+
rows. See here for more info:
http://blogs.msdn.com/excel/archive/...10/694606.aspx

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Blom" wrote:

I have a file that has more than 280 columns and was brought in and saved as
an Excel 2003 file. Because Excel 2003 does not allow for more than 280
columns it only showed the first 280. Now that I have opened that same Excel
2003 dataset in Excel 2007 all 1000 columns are showing up. It appears that
while Excel 2003 only showed the first 280 the whole dataset was still
maintained and now available to me in 2007. Has anyone run into this? Does
this make sense?