Default file locations excel 2007

In this article, I will show you detailed ways to find out the default save location of Excel templates, as well as change the default save location of Excel templates. To find out default save location of your personal Excel templates, just copy and paste the following path into the Address box of a folder window:. For the default Excel template which is applied automatically when creating a new workbook, its default save location is as following:.

Full Feature Free Trial day! Actually, Excel supports users to change the default save location of Excel templates as following steps:.

In the opening Excel Options dialog box, click the Save in the left bar, and enter or paste your custom save location into the Default personal templates location box. In the opening Word Options dialog box, click the Advanced in the left bar, and then click the File Locations button in the General section. In the coming File Locations dialog box, click to select the User templates in the File types box, and click the Modify button.

Free Download You are guest Login Now. Loading comment The comment will be refreshed after To post as a guest, your comment is unpublished. I couldnt find much help online and I ran out of time searching. So here is a workaround, in the Save As dialog window you can find the folder browsing pane on the left. Right click on the Favorite folder Dont left click first and choose the option "Add current locations to Favorites".

Note: This information is also available as a PDF download. To make similar changes in Word , you need to tweak the same options -- but they're not in the same spot.

Click the Browse button to the right of Default File Location and Word will open the Modify Location dialog box, where you can navigate to the desired folder. Note that you can change the default folder for documents as well as templates via the File Locations dialog box -- it's a one-stop shop for tweaking default save locations for all the file types.

Jody Gilbert has been writing and editing technical articles for the past 25 years. Jeeped MVP. In reply to oldjay's post on April 9, Okay, let's take a slightly more aggressive approach. BTW, that's the correct icon for Excel in the above graphic. You will likely want to repeat the procedure for. XLM files. How satisfied are you with this reply?