Added one macro, now all Excel is very slow?

  • Thread starter Thread starter acctemp
  • Start date Start date
A

acctemp

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.
 
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.
 
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.

--
HTH

Bob Phillips

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