Question

Locked

Why has my spreadsheet suddenly slowed down?

By Sue H1 ·
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?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Couple things to look at

by robo_dev In reply to Why has my spreadsheet su ...

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?

Collapse -

Reponse To Answer

by Sue H1 In reply to Couple things to look at

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!)

Collapse -

When you add a worksheet

by LocoLobo In reply to Why has my spreadsheet su ...

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?

Collapse -

Reponse To Answer

by Sue H1 In reply to When you add a worksheet

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!)

Collapse -

9 megabytes is VERY large for a three worksheet 30x140 spreadsheet

by robo_dev In reply to Why has my spreadsheet su ...

Make sure you did not format unused cells or accidentally copy a formula across an entire row

http://www.wikihow.com/Reduce-Size-of-Excel-Files

Collapse -

Reponse To Answer

by Sue H1 In reply to 9 megabytes is VERY large ...

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!

Back to Software Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums