Excel (Office XP) Small Business

  • Thread starter Thread starter Cheryl
  • Start date Start date
C

Cheryl

Excel "hangs" when trying to close. I get messages that
the program is not responding and it freezes. Why????
Takes forever to complete simple tasks. I have tried
the "Repair" option on disk as well as re-installing but
it still freezes. Not all the documents but about every
other one. I am running Windows XP and I have the newest
Dell printer so what is going on?
 
Hi Cheryl

Try this first

Try opening Excel without any Add-ins or hidden workbooks:

On the Windows Taskbar
Start>Run Excel.exe /Safe

If your error is gone, there is either an add-in or a (hidden) workbook that is
Loaded upon XL's start, which is causing problems.
Tools-Addins and uncheck all Addins.
Write down which ones were selected.
Now close Excel and then reopen.

If you don't get the error, then one of the Addins was causing the problem.
Add them back one at a time, closing and opening Excel each time until you find it.

If this didn't stop the error, then the problem is a file in your xlStart directory.
Any file in there Is loaded when you start Excel.
Remove the files out of that folder and open Excel to see if the error is gone.
If it is then add them back one at a time, closing and opening Excel each time until you find it


Also see this webpage

Opening/Saving Bottlenecks (Charles Williams)

http://www.decisionmodels.com/optspeedd.htm#OpSave
 
One of the things that excel does when it's closing is to update your *.xlb file
(where customized changes to toolbars are kept).

Close excel and search for *.xlb. Rename it(them) to *.xlbOld and test it out.

If that fixed the problem, then you'll have to change the toolbar again.
 
Another thing to try (didn't see it suggested, but may have missed it)

After you close excel, clean out your temp directory.
 
Back
Top