Microsoft Office Tutorials and References
In Depth Information
Specify a New Default File Location
Chapter 2: Making It Easier to Manage Workbooks
The Excel Options dialog
3 Click Save.
4 Use the Default File
Location text box to type
the path to the folder you
want to use as the
5 Click OK.
Excel now displays your
folder automatically in
the Save As and Open
Did You Know?
Unfortunately, Excel does not offer a
Browse button or similar feature to help
you choose the folder you want to use as
the default file location. If you are unsure
of the exact path to enter, you can use
Windows Explorer to copy the correct
path. To learn how, see the first Tip in the
section, “Open Workbooks Automatically
at Startup,” earlier in this chapter.
Excel can also accept a network location as
the default file location. This must be a
shared network folder, and you must have
sufficient permissions to save files to the
folder and make changes to the files in the
folder. In the Default File Location text box,
enter a network address in the form
\\ SERVER \ Share , where SERVER is the
name of the network computer, and Share
is the name of the shared folder.