excel - "option" in tools menu kicks me out of excel

[Celia]

Everytime I try to use Excel's "Options" in the Tool
menu it kicks me out and says that it has encountered a
problem and needs to close. Has anyone seen this problem
and is there a way to fix it? Thanks for your help - I
have no clue what to do.

Celia

 

[Debra Dalgleish]

The following MSKB article has some information on this problem:

http://support.microsoft.com/default.aspx?id=168201

 

[Ron de Bruin]

Check out this KB Celia

http://support.microsoft.com/default.aspx?scid=kb;en-us;168201&Product=xlw
XL97: Error Messages Appear Clicking Options on Tools Menu

 

[Celia]

Debra or Ron,
Thanks for the help but I still have some issues. I
now realize I need to change the path to less than 53
characters but I am having problems. When I checked to
see what the default path was (by looking at the file
name that was highlighted when I clicked open file)it is
located in

C:\Documents and Settings\Matthew C. Dieterich\My
Documents

which is well over 53 characters not including the file
name. We upgraded to windows XP and I can't get the path
any smaller. I can't access the general tab in the
options menu to overwrite it beacuse it keeps kicking me
out. Is there another way to change the default path?
UGH!!! Anyway thanks for your help.

 

[Ron de Bruin]

Maybe you can use this macro

Sub Test()
Application.DefaultFilePath = "C:\Data"
End Sub

 

[Gord Dibben]

Celia

If you want to alter the Registry you can temporarily change the default path
to a short enough path to allow you to open Tools>Options. Any valid path
will do(C:\Windows for example). You can then change the path to whatever you
wish as long as it is less than 53 characters.

Assuming you are aware of the precautions taken when editing the Registry and
know how to restore a recent backup of same.......

If not, maybe have a look here first...scroll down to "Registry editing tips"

http://www.activewin.com/tips/reg/index.shtml


With Excel closed.....Start>Run "regedit"(no quotes)

Drill down to HKEY_Current_User\Software\Microsoft\Office\10.0\Excel\Options

Look for "DefaultPath"and select. Edit>Modify. Type your path in here and
close.

Note: 10.0 is Excel 2002. Yours will be 9.0 if 2000 or 8.0 if 97

Gord Dibben XL2002

 

[Celia]

Sorry to keep bothering you. As I was running the macro
it kicked me out with the same error- encountered
problem ... Can you think of anything else? Do you know
if there are any updates to office 97 that fox this
problem.

Celia