If Dave's suggestion doesn't work...........

There was an issue in Version 2002(I believe) since fixed by one of the
Service Packs.

Perhaps you have entered more than 53 characters in the file path to your
default file location in ToolsOptionsGeneral or in the Autorecovery path.

Try re-naming folders in the path to come up with less than 53 characters then
re-enter your new path.

You will have to edit the path in the registry in order
to change the path if you can't get in through ToolsOptions.

HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\E xcel\OptionsAutoRecoverPath
Enter your new path here. Less than 53 characters. You can always change it
later when you get into ToolsOptionsSave


Gord Dibben Excel MVP

On Thu, 08 Dec 2005 14:44:16 -0600, Dave Peterson
wrote:

Maybe you could change it via a line of code:

Open excel
hit alt-F8 to get to the VBE (where macros live)
hit ctrl-g to see the immediate window

type this and hit enter:
Application.AutoRecover.Path = "c:\"

(Actually, if you don't have a C: drive, change that to something else that you
do have.

After you hit enter, it's back to excel and try:
tools|options|save tab
and change it to what you really want.

If your a good typist, you could even do that in that line of code, too. (But
I ain't that good!)



ab wrote:

Hi,

I recently moved to a new computer. I transferred my MS Office settings
from the old computer to the new one. I had set the Autorecover save
location for an excel file on a different partition on the old PC. The
file opens fine on the new computer but under ToolsOptions when I try
clicking on any of the tabs, I get an error message that the partition
cannot be found! So everytime it tries to save an autorecover version,
it cannot and gives an error message, and does not allow me to change
the location! I was wondering if there was another way to change the
location of the default folder, autorecover, etc. I will appreciate any
help.

-ab