Change Default Saving Location

While saving a new workbook or using Save As command, by default, Excel prompts to save all the new workbooks in My Documents folder.

However, many of us don’t always use this folder to save new workbooks. Of course, you can move to the target location in couple of clicks. But if you usually use some other folder to save Excel files, it will be a better idea to directly show that folder in Save As box instead of My Documents. Let’s see how to do that in Excel.

Excel 2010 and later:

File tab > Options > Save tab > Save workbooks segment > Enter entire path of the folder you want in Default file location > OK.

Excel 2007:

Click the Microsoft Office button > Excel Options > Save tab > Save workbooks segment > Enter entire path of the folder you want in Default file location > OK.

Excel 2003:

Tools menu > Options > General tab > Enter entire path of the folder you want in Default file location OK.

That's it. Next time onwards, Excel will prompt to save in above entered path when you open Save As box.

Make sure that the path you are entering exists before entering it in Default file location, otherwise Excel complains.