Results 1 to 2 of 2
Thread: Autofill (Office 97 SR2)
2002-08-26, 15:04 #1
- Join Date
- May 2001
- Thanked 0 Times in 0 Posts
Autofill (Office 97 SR2)
I hope someone can shed some light here. When autofilling using the mouse it is crashing the Excel and a total restart is needed. The user is clicking and dragging down to autofill and when she lifts her finger it has filled nothing and like I said earlier causes the machine to crash.
Any thoughts and suggestions will be much appreciated.
Thanks in advance
2002-08-26, 15:16 #2
- Join Date
- Mar 2002
- Thanked 28 Times in 28 Posts
Re: Autofill (Office 97 SR2)
There might be a problem with custom lists. These are stored (together with other costomizations) in a file with extension .xlb in the Windows folder. Depending on the installation it might be named Excel8.xlb or username8.xlb where username is the login name of the user.
You might try the following:
- <LI>Make sure Excel is not active.
<LI>In Windows Explorer, rename the .xlb file.
<LI>Start Excel (some customizations will be lost) and try autofill.
<LI>Quit Excel. A new .xlb file should appear in the Windows folder (unless Excel crashed again).
<LI>If this was successful, delete the old .xlb file; the user will have to restore other customizations manually.
<LI>If it wasn't, delete the new .xlb file (if there is one) and rename the old .xlb file back.