That setting is stored in the Registry.

Do you have permission to write to the Registry?

See what you have as DefaultPath under this key if you have permission to
StartRun Regedit

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options


Gord Dibben MS Excel MVP

On Thu, 26 Feb 2009 08:09:03 -0800, MBF
wrote:

I want to change the default file location when opening files in Excel v2003.
I have tried tools/options/general and typed in the default file location I
want but when I exit excel and re-open it reverts back to the my documents
file location. Any help?