View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I change File Open default directory from My Documents

ToolsOptionsGeneral

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


Gord Dibben MS Excel MVP

On Sat, 29 May 2010 10:22:01 -0700, Ben
wrote:

Every time I open Excel 2002 and choose File Open it defaults to My
Documents.
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
Documents.
Is there some way to change which directory is default when using File
Open.
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!