Question Locked

Why has my spreadsheet suddenly slowed down?

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
One of my Excel 2007 spreadsheets suddenly takes a long time to open and save. I have been constantly adding additional columns and some new worksheets. Is there a maximum size you should avoid going beyond to prevent this from happening?

7 replies

by robo_dev

First of all, I've seen some incredibly large spreadsheets, tens of thoudands of rows, and it should not slow down Excel all that much.

First of all, how big is your spreadsheet? (file > properties > general)

Are there any database connections or embedded URLs within your sheet?

What about embedded graphics, bitmaps, or charts?

by sue h1

Thanks for your reply. The file is 8905kb, with 3 worksheets, the largest of which has 30 columns and 140 rows. There are no embedded items or connections (none that I have consciously created, that is!)

by locolobo

Do you copy it from another file? Sometimes, Excel decides to link to the old file when you do that. One way to check is to change the view so you can see formulas and look for links.

From your reply to robo_dev, it doesn't sound like there should be a problem. Are using macros in the spreadsheet?

by sue h1

Thanks for your reply. It appears, however, that the problem was due to formatting: I deleted all the unused rows and columns and also removed the borders around the cells. Result: my file is now only 41kb and the speed problem solved. (There were no macros or links, which was why I was puzzled. I'm amazed at the difference in file size by this simple change!)

by sue h1

Eureka! I've deleted all the unused rows and columns (not sure how else to remove unwanted formatting?) and also removed the borders around the cells. Result: my file is now only 41kb and the speed problem solved. Thank you!

This discussion is closed to new replies.