How do I make this load and save faster?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Mitchell - 21 Feb 2007 06:05 GMT

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.

Reply to this Message

Joerg - 21 Feb 2007 09:08 GMT

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

> 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
[quoted text clipped - 11 lines]
> appreciate that this might be better in a database, but I'm not very good
> with these.

Reply to this Message

Chris Mitchell - 21 Feb 2007 11:24 GMT

Thanks Joerg.

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

> 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
[quoted text clipped - 27 lines]
>> appreciate that this might be better in a database, but I'm not very good
>> with these.

Reply to this Message