Added one macro, now all Excel is very slow?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

acctemp@millenniumbank.com - 10 Nov 2006 20:35 GMT

I added a two line macro to clear a range after a button was clicked.
Now this spreadsheet takes 8 minutes to open/close and some unrelated
spreadsheets take 2-3 minutes. Before this change it took at most 5
seconds to open/close all spreadsheets. Saving the file is still very
quick, but printing takes 2-3 minutes. These are fairly small
spreadsheets between 600K-2mb in size with relatively little data.

I tried clearing temp files, rebooting, removing the macro I had just
added, enabling manual calculation, nothing makes a difference. I am
using Excel 2000.

Reply to this Message

acctemp@millenniumbank.com - 10 Nov 2006 21:16 GMT

Hi,

Never mind, lol. By deleting the emf files in a temp directory the
problem was fixed. The strange part is that this directory was
invisible to Windows but I could see it in DOS.

Reply to this Message

Bob Phillips - 11 Nov 2006 10:14 GMT

In windows explorer, select the View tab, and there is an item titled
'Hidden files and folders, make sure this is expanded, and check the 'Show
hidden files and folders' button.

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi,
>
> Never mind, lol. By deleting the emf files in a temp directory the
> problem was fixed. The strange part is that this directory was
> invisible to Windows but I could see it in DOS.

Reply to this Message