auto save path

[Guest]

How do I change a non-existing auto save path in Excel? I missed a backslash
when I wrote the path, but it was accepted by Excel. Now I cannot change it.

 

[Gord Dibben]

Puk

Are you referring to Tools>Options>Save "Autorecovery"?

You can enter a path in the dialog box.

Note: this is not "Autosave"

Autosave saves the file at timed increments you set. This feature was done
away with in Excel 2002 and 2003.

Autosave for Excel 97 and 2000 does not have a user-selected path. It
defaults to your Tools>Options>General "default file location".

Gord Dibben Excel MVP

 

[Guest]

Hi

No, I'm referring to Tools>Options>Save, where I by mistake wrote c:ahotshot
- missing the backslash. Excel should in my opinion have refused to accept
this path, because now I'm not able to make any changes under the various
Options. Error message: No access to 'c:ahotshot'.

 

[Dave Peterson]

if you use c:ahotshot, it'll get saved in the current directory for that C:
drive.

If you change the current directory, then there's a good chance that you don't
have a file called ahotshot.xls in it.

I'd use windows start button|find/search| and look for ahotshot.xls. When you
find it, move it to where you want--a nice safe location.

If you find more than one file, check the last update time/date to make sure you
keep the one you want.

 

[Guest]

My problem is not to find a specific file. Because Excel has accepted this
incorrect path (c:ahotshot - without the backslash to indicate the C drive),
I cannot make any changes in the settings for a document. I can fill in a
worksheet and save it, all right, but how do I get into the Settings to
change this path to the correct c:\ahotshot?

 

[Dave Peterson]

Actually, the C: indicated the drive. By leaving out the backslash
(or the path you intended), you used the current folder on that C:
drive.

This is a valid path.

I'm not sure I understand your problem. If you use windows start
button|search to find that file (no matter where you saved it), you
can move it to where you really want it.

Then you can open and save to the location that you like--probably the
folder that you moved it to????

My problem is not to find a specific file. Because Excel has accepted this
incorrect path (c:ahotshot - without the backslash to indicate the C drive),
I cannot make any changes in the settings for a document. I can fill in a
worksheet and save it, all right, but how do I get into the Settings to
change this path to the correct c:\ahotshot?

<<snipped>>

 

[Guest]

Hi,
I just recently experienced the same thing, and searched on the internet to
try to find answers. I didn't, but I just found the solution. Make a macro,
where you change the autorecovery path:

Sub SetPath()

Application.AutoRecover.Path = "C:\"

End Sub

Run this - and then the problem is solved.

Good luck!

 

[Dave Peterson]

Autorecovery is different than autosave.

Autosave will save the workbook in place--autorecovery will save a copy of that
workbook to the user's choice of folders (also under tools|Options|save tab in
xl2002+) as a funny named file with an extension of .xar.