Excel save as problem

[Gabor]

Hi all

I have a very interesting problem on a few of my supported computers.

In Excel by default when I open a file from a location (for example Z:\test)
and I try to save a copy of this file with save as then in the save as window
the deffault path will be where the original file is (Z:\test).

Since a few days ago when the users click on save as, then the default save
as location will be the "Default file location".

Is there a way to change this setting back to default?

Thank You for Your help in advance

[NAVEEN]

Hi,

- Goto "Tools->Options" Menu

- Click on "General" Tab

- Change the location, whatever you wish in "Default file location:"


Regards
NAVEEN





"Gabor" wrote:

> Hi all
>
> I have a very interesting problem on a few of my supported computers.
>
> In Excel by default when I open a file from a location (for example Z:\test)
> and I try to save a copy of this file with save as then in the save as window
> the deffault path will be where the original file is (Z:\test).
>
> Since a few days ago when the users click on save as, then the default save
> as location will be the "Default file location".
>
> Is there a way to change this setting back to default?
>
> Thank You for Your help in advance

[Jim Rech]

This may be version dependent and you didn't mention the version of Excel
you have, but a dword registry key named:

AlwaysSaveToCurrentPath

under:

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options

(where the "9.0" should be adjusted to your version) when set to zero will
default an opened workbook to "save as" the same folder it was opened from
(rather than the current folder).

--
Jim
"Gabor" <Gabor@discussions.microsoft.com> wrote in message
news:FEF8F7B7-273F-421B-8D77-B0F08347FCDA@microsoft.com...
| Hi all
|
| I have a very interesting problem on a few of my supported computers.
|
| In Excel by default when I open a file from a location (for example
Z:\test)
| and I try to save a copy of this file with save as then in the save as
window
| the deffault path will be where the original file is (Z:\test).
|
| Since a few days ago when the users click on save as, then the default
save
| as location will be the "Default file location".
|
| Is there a way to change this setting back to default?
|
| Thank You for Your help in advance

[Gabor]

Thank You for Your help.

I created the key in the registry and it has solved my problem.

Kind Regards

Gabor

"Jim Rech" wrote:

> This may be version dependent and you didn't mention the version of Excel
> you have, but a dword registry key named:
>
> AlwaysSaveToCurrentPath
>
> under:
>
> HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
>
> (where the "9.0" should be adjusted to your version) when set to zero will
> default an opened workbook to "save as" the same folder it was opened from
> (rather than the current folder).
>
> --
> Jim
> "Gabor" <Gabor@discussions.microsoft.com> wrote in message
> news:FEF8F7B7-273F-421B-8D77-B0F08347FCDA@microsoft.com...
> | Hi all
> |
> | I have a very interesting problem on a few of my supported computers.
> |
> | In Excel by default when I open a file from a location (for example
> Z:\test)
> | and I try to save a copy of this file with save as then in the save as
> window
> | the deffault path will be where the original file is (Z:\test).
> |
> | Since a few days ago when the users click on save as, then the default
> save
> | as location will be the "Default file location".
> |
> | Is there a way to change this setting back to default?
> |
> | Thank You for Your help in advance
>
>
>