Changing File Location on General Tab

M

mfanclub

I know how to change a file location in Excel for the
default location on the general tab. My problem is that
location no longer exists, so I need to change it. Now I
cannot get the General tab to open because it simply gives
me a message that it cannot find the old location. Is
there a way around this so I can get the General tab open
and make the location change?

Office XP

Thanks!
 
B

Bernie Deitrick

You can use RegEdit to change it: Change the value in

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Excel\Options\AltStartup

HTH,
Bernie
MS Excel MVP
 
B

Bob Phillips

Try this bit of code

With Application
.DefaultFilePath = "d:\Bob\My Documents\My Spreadsheets"
End With

with your folder of course.

How did you do this? When Excel is active, it will stop you as it is using
that directory.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
B

Bernie Deitrick

I'm sorry, you should change the DefaultPath key, not the AltStartup key....

HTH,
Bernie
MS Excel MVP
 
M

Myrna Larson

Another workaround, for those who know what the old path was and are leery of
messing with the registry, is to quick re-create that directory outside of
Excel, start Excel, make the necessary changes on the General tab, quit Excel
and then remove the directory again.
 
B

Bob Phillips

Now that is a smart suggestion, and so obvious (when someone has said
it<g>).

Bob
 
M

Myrna Larson

I had do do just that once with TurboTax. I had the data files on drive D. My
new computer didn't have a Drive D... It was a bit of a hassle to create a new
drive and directory, but the folks at Intuit had no clue as to how to resolve
the problem. I hope the OP doesn't have the problem of a non-existent drive as
well as a non-existent directory.
 
M

mfanclub

Thank you Bernie, that worked like a champ. Another
problem she is still having is that she cannot open any of
the options tabs because the old location is still in
there somewhere. She cannot autosave because that also is
still listing the old location. Any further suggestions on
how to get those options tabs to open once again so she
can make any option changes she needs to?

Thanks!
 
M

mfanclub

I figured it out, you go into the same registry area and
change the AUTORECOVERY key to the new location. After
this she was able to open all her options tabs.

Thanks!
-----Original Message-----
Thank you Bernie, that worked like a champ. Another
problem she is still having is that she cannot open any of
the options tabs because the old location is still in
there somewhere. She cannot autosave because that also is
still listing the old location. Any further suggestions on
how to get those options tabs to open once again so she
can make any option changes she needs to?

Thanks!
Click to expand...
 
Top