Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2002: What happen to the extra rows and columns ?
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: Any formula to tranpose columns into rows ? | Excel Discussion (Misc queries) | |||
extra rows and columns | New Users to Excel | |||
I cannot delete rows or columns in Excel 2002. How do I fix this? | Setting up and Configuration of Excel | |||
delete extra columns and rows | Excel Discussion (Misc queries) | |||
how do i delete the extra empty rows and columns that i dont need. | Excel Discussion (Misc queries) |