Auto save location

[Ryan]

I have a very strange problem. I have Excel 2003 setup to
automatically save files to the My Documents directory by
default, however when I go to "save as" the default
directory that shows up is c:\documents and
settings\joe\local settings\temporary internet\OLK5. Can
anyone tell me what this is all about and how to fix it?
I don't understand why Excel is looking there even though
the default file location is set to My Documents. I have
searched the web and cannot find anything. Your help is
greatly appreciated.

 

[Ryan]

No, I don't have a macro running. I agree that it should
go to the last directory referenced but it is not. Do you
have any other ideas?

-----Original Message-----
Do you have a macro running that may be going to that

location? "Save As" in Office 2002 goes to the last
directory referenced, and not the default.

 

[Guest]

Who is "JOE"? Are you on a shared machine? Are you logging in with an admin ID, or as a restricted user?

Out of curiosity, where is your auto-recover save location pointing to?

 

[Dave Peterson]

Since xl2k (IIRC), if you open a file, excel will show you that file's folder
when you do a file|saveAs.

And since you're going to that OLK5 location, I'm betting you're reading an
attachment in your email--that's where your email stores the file when you click
on it to read it.

I don't know of a way to change this behavior.

(But I'm usually glad it works this way. If I open one of my own files and do a
File|SaveAs, I usually want to save it in the same folder.)

And I do agree that it's a pain with attachments to emails.

But hope isn't lost

Since you're using xl2003, you can do this:

Next time you're in the File|open (or File|SaveAs) dialog, traverse to your
favorite folder (but just select it--don't go into it)

Then click Tools|Add to My Favorites.

Now, you can just click on that shortcut in the "look in" toolbar (left hand
side of the File|open/SaveAs dialog).

====
If you're using xl2k: You could use an addin from MS:

It's called Places.exe that allows you to update the places list.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q253338
INFO: Office Developer Samples and Tools Available for Download (Q253338)

Scroll about halfway down.