TheExcelAddict.com
Microsoft Excel "Quick Tips"

Choose Your Own Default File Location

Now you're saying, 'What the heck is a Default File Location?' The default file location is the folder that Excel presents you with when you open or save a file.

By default, Excel uses C:\My Documents as the default file location. Just try it. Click File, Open and see which folder comes up.

If you'd prefer to save you files in a different location, for example maybe you always open and save your files on a network, you can easily change this location. Select Tools, Options and click on the General tab. In the 'Default file location' field, type in your desired folder, including the file path (i.e. F:\Accounting\2003 Files\).