Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To many rows in worksheet in 2007
I have the max number of rows showing up every time I open a workbook or add
a sheet. How do I get my sheets to go back to 60,000 rows? I tried to delete them but they don't go away, I've tried to set up a template with 60,000 rows but when I open it up I have the million rows back. Having a million rows takes up to much time when opening, saving, etc. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To many rows in worksheet in 2007
Hi Zoolady
In fact the opposite is true. 2007 with it's 'million' rows opens faster and takes up less space on the disk than previous versions of Excel. Slow opening is usually due to some fancy links in your spreadsheet. Check Data -- Edit links and make sure all your links refer to valid paths. If this helps, please click "Yes" <<<<<<<<<<< "zoolady" wrote: I have the max number of rows showing up every time I open a workbook or add a sheet. How do I get my sheets to go back to 60,000 rows? I tried to delete them but they don't go away, I've tried to set up a template with 60,000 rows but when I open it up I have the million rows back. Having a million rows takes up to much time when opening, saving, etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get my Excel 2007 worksheet to go beyond 65536 rows? | Excel Worksheet Functions | |||
Copy rows from one worksheet automatically, ignore rows that are b | Excel Worksheet Functions | |||
Import an MS Money 2007 file into MS Excel 2007 worksheet | Excel Discussion (Misc queries) | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
How do I insert blank rows between rows in completed worksheet? | Excel Discussion (Misc queries) |