Cannot change Excel 2002 working directory

[Jerry]

I am unable to change the working directory for Excel 2002.
The os is XP Pro. While previously in a network workgroup I
created the default working directory
(H:wp51\wpdocs\qpdocs) on the server "H". I am no longer on
this network and wish to change the default working
directory to a local file. When attempting to change the
default working directory through tools/options the
following message is generated: Cannot access directory 'H:
\wp51\wpdocs\qpdocs'.

I have run regserver and modified the registry by adding
NetworkResiliency and PivotTableNetworkResiliency without
success. I am able to save a new worksheet to the file
which will be the default directory once this "default"
issue is solved. It simply requires a few more annoying
mouse clicks. Any ideas or suggestions would be greatly
appreciated.
regards, jerry young

 

[Dave Peterson]

I'm not sure if this will work, but it's easy to try:

Start Excel
hit alt-f11 to get to the VBE (where macros live)
hit ctrl-G to see the immediate window
type this in and hit enter:

application.DefaultFilePath = "c:\"

then close the VBE and back to excel to see if you can change it then.

(if you're a good typist, you could try typing in the real new path.)

If that doesn't work, then are you up for editting the registry?

In xl2002 (under win98), this setting is stored in:
HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\excel\Options
Look for DefaultFilePath
double click on it and change it there

If you're hesitant, back up the registry before making any change. In fact,
that's probably a good idea anytime!

 

[Dave Hawley]

Hi Jerry

No idea if this will work, but try Detect and repair under help.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****