Slow Spreadsheet

[Guest]

Hi,

I have a spreadsheet about 3.5Mb wich is very slow to navigate into it and
modify data and formula.

I have try to put it to manual calculation but without any significant
progress in the response time.

I have a couple of other very very similar spreadsheet that run and react
smootly.

At home or at work or on another computer all this still the same. The only
thing that affect the response time is the power of the computer wich is just
normal...

Any idea what's going on?

Regards.

 

[Chip Pearson]

The only thing I can think of is that you have some VBA running
when the selection changes. Open the VBA Editor (ALT+F11), then
the Project Explorer (CTRL+R). Double-click the ThisWorkbook
module and see if there is any code there. If so, you might want
to delete it (depending on what it does and whether you need it).
Do the same for each worksheet.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com