Excel 2003 to Excel 2007 Compatability

[JF]

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?

 

[Peo Sjoblom]

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

 

[Dave Peterson]

Open the file in xl2007.
Save the file as a normal xl2007 file (.xlsx or .xlsm).
Close the file.
Reopen the file.

 

[Sheeloo]

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

 

[Peo Sjoblom]

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 button>convert then save as *.xlsx

--


Regards,


Peo Sjoblom