| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
Excel 2007 # of rows
Good find.
I had forgotten about that. It has been discussed before. Gord On Tue, 4 May 2010 10:58:04 -0700, NTXCoog wrote: We have found the problem. If you set the default Save format under Options to Excel 97-2003, any newly created workbooks will be limited to the 65536 rows. I changed the default Save format to xlsx and now it creates new workbooks in the new format with 1 million+ rows. It makes sense, but I didn't associate the Save default with the workbook creation. Thanks to everyone for the assistance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to have more than 65,000 rows in excel 2007 | Excel Discussion (Misc queries) | |||
| decimate rows in Excel 2007 | Excel Discussion (Misc queries) | |||
| Excel 2007 rows | Excel Discussion (Misc queries) | |||
| How can I see more than 65,536 rows in Excel 2007? | Setting up and Configuration of Excel | |||
| How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Hybrid Mode
