very slow to open excel file

  • Thread starter Thread starter alex
  • Start date Start date
A

alex

hello, my computer in office is using WIN 98 SE, i found that it's too
slow to open an excel file recently. please help

thanks a lot
 
Hi Alex!


Most probable causes are:



Too much accumulated junk in:

C:\Windows\Temp File


Shut down your computer and re-start. Then delete all contents of the
C:\Windows\Tem file

Alternative might be a bloated Excel.xlb file.

Locate the Excel.xlb or Excel10.xlb file using Start > Search > For
Files and Folders. The xlb file should not be above around 30kb and is
usually much smaller. If it is bloated, there's not a lot that can be
done with it but you should move it from it's current location.

The xlb file is where Excel stores your toolbar settings and any
special toolbars or buttons that you create. Don't worry about the
absence of one of these files. When Excel completes the next
successful open and close, you will find it has created a new file. As
a precautionary measure. Once you have done any messing about with
your toolbars to get them how you want or to add new toolbars or
buttons, you should take a backup copy of it. If it bloats again, at
least you won't have to go back to scratch.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top