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?