View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Excel 2002: What happen to the extra rows and columns ?

The data won't be there--it's lost.

You have to use xl2007 if you want to use have more than 64k rows per worksheet.

Mr. Low wrote:

Dear Sir,

I understand that there is a format convertion update that enanle Excel 2002
to open Excel 2007 XML file format.

If open an Excel 2007 worksheet that has 250,000 rows and 75 columns more
that the maximum limit of the Excel 2002, what would happen to those
"Overflow" data ? Will it appear orderly in the next page ?

If I wish to work on the data sets with original Excel 2007 row and column
layout in Excel 2002 is it an imposible task except to switch to Office 2007
?

Thanks

Low

--
A36B58K641


--

Dave Peterson