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.m...l/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.

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> 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.m...l/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.
>
>

Thanks Joerg.

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

"Joerg" <(E-Mail Removed)> wrote in message
news:erh25q$5e8$(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> 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.m...l/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.
>>
>>
>
>