When you done with a workbook and save it, Excel will save it to My Documents folder automatically. But sometimes you need to save the workbook to another folder which is more consistent with the use of your habits. In this case, you need to select the correct location in the Save As dialog box, and it may be annoying for you to choose the folder each time. Here I’d like to give a simple guide of how to change the default save location in Excel, to solve the problem once and for all.
First, click File in the upper left corner.
Next, click Options on the list page.
When”Excel Options” window appears, choose the option “Save“.
Go to Save workbooks section, you can modify a new location in the box of Default local file location.
Simply click OK, and you have already changed the default save location. Next time when you deal with workbooks, it will be automatically saved at the related location you’ve changed.