Slow response in spreadsheet

I use an Excel 2000 spreadsheet to keep track of my net worth, updating it
daily from a stockmarket summary. Lately it has slowed horribly. I've done
all the usual things, i.e. deleted temporary internet files, defragged,
lowered the security setting that usually slow things up but to no avail.

Any suggestions?

Droopy

David McRitchie has some notes on slow response at:
http://www.mvps.org/dmcritchie/excel/slowresp.htm

And did you try cleaning your temp folder?

Windows start button|run
%temp%

is a quick way to get there.



Robin Cowdrey wrote:
>
> I use an Excel 2000 spreadsheet to keep track of my net worth, updating it
> daily from a stockmarket summary. Lately it has slowed horribly. I've done
> all the usual things, i.e. deleted temporary internet files, defragged,
> lowered the security setting that usually slow things up but to no avail.
>
> Any suggestions?
>
> Droopy

--

Dave Peterson

Hi,

I had cleaned up my temp file, defragged, turned off my virus checker,
Turned on Task Manager only to find every time I clicked on a cell, the CPU
shot up to 100% usage and stayed there for ever. I cleared all formulae and
the graph I had embedded. I then noticed that the file was huge (6.61MB) so
I copied all the data and used Paste Special/Values to paste it to a new
file. I reentered the formulae, formatted exactly the way the old
spreadsheet was. It works fine and occupies a scant 29KB. There is a
6.58MB monster lurking in that spreadsheet somewhere! I haven't deleted it
and am, of course, curious about the monster. I checked for macros - there
are none. If anyone has any idea what it might be or how I can find what
the monster is, please let me know. Otherwise, I'll send it to teh Recycle
Bin.

Robin

"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> David McRitchie has some notes on slow response at:
> http://www.mvps.org/dmcritchie/excel/slowresp.htm
>
> And did you try cleaning your temp folder?
>
> Windows start button|run
> %temp%
>
> is a quick way to get there.
>
>
>
> Robin Cowdrey wrote:
>>
>> I use an Excel 2000 spreadsheet to keep track of my net worth, updating
>> it
>> daily from a stockmarket summary. Lately it has slowed horribly. I've
>> done
>> all the usual things, i.e. deleted temporary internet files, defragged,
>> lowered the security setting that usually slow things up but to no avail.
>>
>> Any suggestions?
>>
>> Droopy
>
> --
>
> Dave Peterson

Post back if you ever figure it out.

Robin Cowdrey wrote:
>
> Hi,
>
> I had cleaned up my temp file, defragged, turned off my virus checker,
> Turned on Task Manager only to find every time I clicked on a cell, the CPU
> shot up to 100% usage and stayed there for ever. I cleared all formulae and
> the graph I had embedded. I then noticed that the file was huge (6.61MB) so
> I copied all the data and used Paste Special/Values to paste it to a new
> file. I reentered the formulae, formatted exactly the way the old
> spreadsheet was. It works fine and occupies a scant 29KB. There is a
> 6.58MB monster lurking in that spreadsheet somewhere! I haven't deleted it
> and am, of course, curious about the monster. I checked for macros - there
> are none. If anyone has any idea what it might be or how I can find what
> the monster is, please let me know. Otherwise, I'll send it to teh Recycle
> Bin.
>
> Robin
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
> > David McRitchie has some notes on slow response at:
> > http://www.mvps.org/dmcritchie/excel/slowresp.htm
> >
> > And did you try cleaning your temp folder?
> >
> > Windows start button|run
> > %temp%
> >
> > is a quick way to get there.
> >
> >
> >
> > Robin Cowdrey wrote:
> >>
> >> I use an Excel 2000 spreadsheet to keep track of my net worth, updating
> >> it
> >> daily from a stockmarket summary. Lately it has slowed horribly. I've
> >> done
> >> all the usual things, i.e. deleted temporary internet files, defragged,
> >> lowered the security setting that usually slow things up but to no avail.
> >>
> >> Any suggestions?
> >>
> >> Droopy
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson

If you're copying data from a web site, you may also be copying
invisible objects. You could try to find and delete them:

To select all the objects on the sheet --
Choose Edit>Go To, click Special
Select Objects, click OK

Or, to work with specific objects, you can add the 'Select Multiple
Objects' tool to one of your toolbars:

Choose Tools>Customize
Select the Commands tab
Select the Drawing Category
Drag the 'Select Multiple Objects' tool onto one of your toolbars
Click Close

Then, click the Select Multiple Objects button, and select any or all
objects on the worksheet.


Robin Cowdrey wrote:
> Hi,
>
> I had cleaned up my temp file, defragged, turned off my virus checker,
> Turned on Task Manager only to find every time I clicked on a cell, the
> CPU shot up to 100% usage and stayed there for ever. I cleared all
> formulae and the graph I had embedded. I then noticed that the file was
> huge (6.61MB) so I copied all the data and used Paste Special/Values to
> paste it to a new file. I reentered the formulae, formatted exactly the
> way the old spreadsheet was. It works fine and occupies a scant 29KB.
> There is a 6.58MB monster lurking in that spreadsheet somewhere! I
> haven't deleted it and am, of course, curious about the monster. I
> checked for macros - there are none. If anyone has any idea what it
> might be or how I can find what the monster is, please let me know.
> Otherwise, I'll send it to teh Recycle Bin.
>
> Robin
>
> "Dave Peterson" <[email protected]> wrote in message
> news:[email protected]...
>
>> David McRitchie has some notes on slow response at:
>> http://www.mvps.org/dmcritchie/excel/slowresp.htm
>>
>> And did you try cleaning your temp folder?
>>
>> Windows start button|run
>> %temp%
>>
>> is a quick way to get there.
>>
>>
>>
>> Robin Cowdrey wrote:
>>
>>>
>>> I use an Excel 2000 spreadsheet to keep track of my net worth,
>>> updating it
>>> daily from a stockmarket summary. Lately it has slowed horribly.
>>> I've done
>>> all the usual things, i.e. deleted temporary internet files, defragged,
>>> lowered the security setting that usually slow things up but to no
>>> avail.
>>>
>>> Any suggestions?
>>>
>>> Droopy
>>
>>
>> --
>>
>> Dave Peterson
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html