change the default working folder

[Scott]

How do I change the default working folder in Excel? I've followed the
instructions on the help, but it changes back every time I close the program.

 

[Gord Dibben]

Assuming these are the instructions you followed from help

..............................................................

This procedure sets the default folder for opening and saving Microsoft Excel
files.

On the Tools menu, click Options, and then click the General tab.
In the Default file location box, type the path for the folder you want to
display as the default working folder.
For example, type c:\work.

..................................................................

Has this not been saving since you first installed Excel or is it a recent
development?

What is the current path/folder that will not change?

Are you on a network or standalone system?

This setting is stored in the Registry.

Are you sure your account allows you to save these types of settings.


Gord Dibben MS Excel MVP