When you set up the default directory for saving that will also be the first
directory that it goes to the first time you do a save as on a file after you
open Excel.

However, once you have done a Save As on a file to a different directory
then when you try to open or do another Save As it will go to the last
directory that you were in.

I am not aware of any way to get the File Open to always go to the same
directory.

I usually keep Windows Explorer Open and if you have moved to that directory
then you can just pop it up and select the file from there and it will open
in Excel.

Not the best way but it is a quick alternative.
--
Alan


"Lynn" wrote:

Under Excel Options, there is only a default save directory. I want to be
able to always be directed to a frequently used subdirectory.