How do I make this load and save faster?

[Chris Mitchell]

I have an Excel 2002 SP3 Worksheet that extends to cell J:210. This uses
data validation in slightly less than a third of the cells and sums the
validated data in approx 17 rows. This creates a 288 KB file which is slow
to open and save on my WIN XP Home Pentium 4 CPU 3.00GHz, 1.00 GB RAM PC.
See 'example.xls' at
http://www.btinternet.com/~chris.a.mitchell/oddsandsods/ This worksheet
needs to be repeated several times in a workbook which becomes very slow to
open and save.



I have disabled Add-Ins to improve Excel opening times, but still this
Worksheet takes a long time to do anything with.



Any suggestions as to how to speed this up would be most welcome. I
appreciate that this might be better in a database, but I'm not very good
with these.

 

[Joerg]

You have hundreds of embedded "equation" objects on this page. No idea why
you need them, but after deleting all this (invisible) stuff the file saves
normally. Before that the file took ages to save and even at one point
crashed Excel.

To select all these objects at once: F5 => Special => Objects => OK, then
delete.

Cheers,

Joerg Mochikun

 

[Chris Mitchell]

Thanks Joerg.

This reduced the file size from 228 KB to 44 KB which is much faster.