To many rows in worksheet in 2007

  • Thread starter Thread starter zoolady
  • Start date Start date
Z

zoolady

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.
 
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"
<><><><><><><><><><><>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about copying long rows of data 2
Quick/efficient way to VBA subtotal 2
How to have more than 65,000 rows in excel 2007 3
sumif (maybe) 1
Looking up the same part numbers from multiple pages and listing e 2
How do I remove empty Rows 2
Adding time 2
Chart graph from worksheet but need to exceed 256 columns 2

Back
Top