Sudden problem with Excel workbooks containing VBA

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2000 on Windows 2000 Compaq Evo notebook suddenly takes an excessive time to open and close workbooks with VBA macros. CPU resource is almost entirely used by Excel.exe during the open or close process. These workbooks previously worked fine. It seems to be restricted only to workbooks with VBA macros. Virus scan doesn't show any infection. Otherwise, Excel works fine when workbooks finally open ....????
 
And one more thought.

If you start excel in safe mode,
windows start button|Run
excel /safe

then File|Open your file (macros will be disabled), does it load quicker.

Maybe it's not the workbook that's causing the trouble. Sometimes the
customized toolbar file gets corrupted and slows excel down. (Safe mode stops
it from loading, too.)

Close excel
search for *.xlb.
Search through hidden folders and hidden files, too.

Rename any you find to *.xlbOLD.

Then restart excel. If that worked, then dump those *.xlbOLD and recreate your
customized toolbars when you have time.
 
Back
Top