Slow Spreadsheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yaourt - 10 Jun 2006 14:53 GMT

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.

Reply to this Message

Chip Pearson - 12 Jun 2006 00:17 GMT

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.

Signature

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

> Hi,
>
[quoted text clipped - 19 lines]
>
> Regards.

Reply to this Message