Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 to Excel 2007 Compatability
In the compatibility mode when saving an Excel 2003 file as a 2007 file,
there is still the 65,000 line constraint in the 2007 file. How do I allow for up to 1 million rows without having to recreate the 2003 file from scratch in 2007? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 to Excel 2007 Compatability
Not possible, you would need to split it between
multiple sheets if you use previous versions. The compatibility pack just allows it to be imported in earlier version and it will convert it to pre 2007 files format and let you know that some features cannot be imported. -- Regards, Peo Sjoblom "JF" wrote in message ... In the compatibility mode when saving an Excel 2003 file as a 2007 file, there is still the 65,000 line constraint in the 2007 file. How do I allow for up to 1 million rows without having to recreate the 2003 file from scratch in 2007? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 to Excel 2007 Compatability
Open the file in xl2007.
Save the file as a normal xl2007 file (.xlsx or .xlsm). Close the file. Reopen the file. JF wrote: In the compatibility mode when saving an Excel 2003 file as a 2007 file, there is still the 65,000 line constraint in the 2007 file. How do I allow for up to 1 million rows without having to recreate the 2003 file from scratch in 2007? -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 to Excel 2007 Compatability
If you are working in 2007 then save the file as XLSX (2007 default format)
and you should get 1 million rows... If you are working in 2003 and saving as 2007 format then you will have the limitations of 2003 "JF" wrote: In the compatibility mode when saving an Excel 2003 file as a 2007 file, there is still the 65,000 line constraint in the 2007 file. How do I allow for up to 1 million rows without having to recreate the 2003 file from scratch in 2007? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 to Excel 2007 Compatability
I probably misunderstood what you meant. If you just
want to take a file created in 2003 and make it accept million rows in 2007 you can convert it under office buttonconvert then save as *.xlsx -- Regards, Peo Sjoblom "Peo Sjoblom" wrote in message ... Not possible, you would need to split it between multiple sheets if you use previous versions. The compatibility pack just allows it to be imported in earlier version and it will convert it to pre 2007 files format and let you know that some features cannot be imported. -- Regards, Peo Sjoblom "JF" wrote in message ... In the compatibility mode when saving an Excel 2003 file as a 2007 file, there is still the 65,000 line constraint in the 2007 file. How do I allow for up to 1 million rows without having to recreate the 2003 file from scratch in 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 compatability mode, can't open when saved by excel 2003 | Excel Discussion (Misc queries) | |||
Compatability Issues between 2007 and 2003 | Excel Discussion (Misc queries) | |||
2007 Compatability Pack for Office 2003 | Excel Discussion (Misc queries) | |||
Office 2003 and 2007 compatability install | Excel Discussion (Misc queries) | |||
Excel compatability 2003-2007 | Setting up and Configuration of Excel |