I have 2007 on my computer and it has 65536 rows and 256 columns, just like
the 2002 version I had before. How do I get the full 2007 rows and columns?
Thank you for your time. Jim

Create a new workbook. Or save the old xls workbook in the new format.

Bob Flanagan
Macro Systems
144 Dewberry Drive
Hockessin, Delaware, U.S. 19707

Phone: 302-234-9857, cell 302-584-1771
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"Jim" wrote in message
...
I have 2007 on my computer and it has 65536 rows and 256 columns, just like
the 2002 version I had before. How do I get the full 2007 rows and
columns? Thank you for your time. Jim

Existing .xls files made with earlier versions will open in compatibility
mode with the same row/column limits as the version they were created in.

New files created in 2007 and saved in 2007 format(s) will (should) have the
extended limits.

"Jim" wrote:

I have 2007 on my computer and it has 65536 rows and 256 columns, just like
the 2002 version I had before. How do I get the full 2007 rows and columns?
Thank you for your time. Jim

Office ButtonExcel OptionsSaveSelect Save files in Excel Workbook
(*.xlsx) format.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.



"Jim" wrote in message
...
I have 2007 on my computer and it has 65536 rows and 256 columns, just like
the 2002 version I had before. How do I get the full 2007 rows and
columns? Thank you for your time. Jim