![]() |
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
|
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! |
| Ads |
|
#2
|
|||
|
|||
|
Quote:
for "default file location". give the default file location, it will open from this path by default. all the best
__________________
Thanks Bala |
|
#3
|
|||
|
|||
|
Tools>Options>General
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! |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How can I change default file for saving documents? | Anna | Excel Discussion (Misc queries) | 1 | November 5th 09 12:59 AM |
| change directory to list default | edbrog | Excel Discussion (Misc queries) | 2 | January 31st 09 06:19 PM |
| How do I set up an Excel 2007 default directory for a File Open? | Lynn | Excel Discussion (Misc queries) | 1 | April 15th 08 05:30 PM |
| Open to default directory in Excel | Odawg | Excel Discussion (Misc queries) | 7 | October 14th 05 05:23 AM |
| How do I change file/open/"files of type" to default to "all file. | How do I changefiles of type default | Excel Discussion (Misc queries) | 1 | April 19th 05 10:45 PM |