Excel spreadsheets opening and closing VERY slowly

[ajbeer]

I have a problem, and I really don't know what the reason might be. I would very much appreciate any help anybody could give me.

I am using Excel 2000 in Windows 98.

When I open certain spreadsheets that I have been working on, they open and close extremely slowly.

This only started yesterday.
My spreadsheets were using an Excel timer to calculate some data (that was being read in using DDE) every 5 mins.

This spreadsheet will be left on all year round, so I realised that using this method would give me a problem when the hour changes at the end of March and October.
I then changed my VBA code to use the Windows API timer function setTimer.
This seemed to work, as the data was being updated correctly every 5 mins, but I started getting exception errors in Excel every now and then.

Now whenever I try to open any of these files, it displays the message asking whether macros should be enabled, as normal, but then just takes ages to finally load. It also takes a vey long time to close down too.

If anyone has any ideas, I would be very grateful.
If you need any more info. that might help you answer my quesry, please let me know.

Thanks.

 

[doughahn]

use ctrl alt delete to see if "wscript" is running if it is , end the task for wscript...this will speed you back up, if I remember right its a virus that causes wscript to run on startup