Tips for Excel, Word, PowerPoint and Other Applications

Changing the Default Save Location For Your Excel Files

Why It Matters To You

By default, your new Excel workbooks go into My Documents. Sometimes we may want to put them somewhere else that is more convenient for us. If you find yourself always putting Excel documents into the same folder, rather than My Documents, it may make sense to change the default so that you automatically save there, instead of constantly moving files back and forth.

How To ...

Go to Tools:Options

Select the General tab, and then change the file location in the Default File Location line.

You should be able to change the default file location to any local drive, but not a network drive. That's it. Wasn't that simple?

Notes

Last updated9/3/07
Application VersionExcel 2003
AuthorMichael Kan
Pre-requisitesNone
Related TipsNone