Options "General" tab not accessible

[Oregon48]

Pc being used (inherited) by new user, and tools-options-general tab has default folder set to one that user cannot access. When you click on the General tab you get the standard "Cannot access directory" hate message, but when you click OK - it simply stays on the view tab. So you do not have an opportunity to delete the offending directory and put your own default in. Any ideas how to get around this annoying circle game.
Thanks
Al@alsbowl.com

 

[dcompto]

The designated path is invalid. Can you see what path was designated? If so, and if possible, create that same path then open Excel and go back to Tools > Options > General tab and see if it will let you change it.

 

[dcompto]

Thought of something else...Try using the /p startup switch to force Excel to use the path you specify as the default file location:

Start > Run
type: C:\Program Files\Microsoft Office\Office\Excel.exe" /p "C:\[path]"
OK

You may have to modify the Excel path for whatever version you are using. The above is path of Excel 2000 default installation.

 

[Oregon48]

Thanks Dcompto for the 2 ideas. Yes the error message does give the offending path, and although it was a network drive designated for users, user could recreate the folders as noted by previous user. On the /P option, that did not work becasue although it started up with the new default, the general tab still had the offending directory. thanks again for the help

 

[xlbo]

you could try running some VBA:
open file
run this code

application.DefaultFilePath = "c:\home"

save file
file path should be reset

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question