How do I change File > Open default directory from My Documents



Every time I open Excel 2002 and choose File > Open it defaults to My
While working in Excel, it will always remember the last directory I was in.
When I close, and then relaunch Excel, File > Open defaults back to My
Is there some way to change which directory is default when using File >
I would like to do this without registry edits or changing the target path
of My Documents shortcut if possible.
Thanks in advance for any help!

Gord Dibben


Default File Location is where you enter the path to your desired folder.

Gord Dibben MS Excel MVP

Paul Calcagno


Default File Location  is where you enter the path to your desired folder.

Gord Dibben  MS Excel MVP

Gord, I'm using Office 2007. I don't have a Tools icon to click on so
how to I follow this recommendation. Actually, if I select tools from
the new commands list it appears along with the other icons at the top
of the page, but when I right or left click it there's no
Option>General path for me to follow.
Thanks............Paul C

Gord Dibben


The recommendation was for OP who was using 2002.

For 2007..............Button>Excel Options>Save

"Default file location" is where you enter the path.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question