Excel 2002: What happen to the extra rows and columns ?

G

Guest

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? 2
What is the Excel 2007 rows limit for Excel 2003 macros? 0
Where are the extra columns and rows? 6
I cannot delete the extra rows or columns in Excel 2007 2
Importing CSV file with more than 65535 rows to Excel 2007 9
Pivot table data layout - columns to rows 1
Restrict add rows and columns 3
Excel 2002 : Anway to paste without time values ? 3

Top