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