Once the field is cleared, click into it so that the cursor is blinking, and press on your keyboard: Ctrl and V at the same time. Delete the contents of the "Default File Location" fieldġ0. Hi, Ive got an excel 2003 template, when users open this file, Id would like the users to save it to a location specific for that document. Right click the selected address and select "Copy"ĩ.
Highlight the address: C:\Documents and Settings\(Your Profile Name)\My Documentsĥ. You will notice now that in the "Address" field near the top of the Windows Explorer, the address says: C:\Documents and Settings\(Your Profile Name)\My DocumentsĤ. Click once on the "My Documents" folder on the left hand side of the Windows Explorer so that it is highlightedģ. This will bring up the Windows Explorer, open to your profiles "Start Menu" folderĢ. in the Locale (location) drop-down menu and select your desired location.
Right click on your "Start" button and select "Explore". Microsoft Excel allows us to change the default date format and select another. In the pop-up Excel Options dialog, find Default view for new sheets in right section, and choose the view you want to specify from the drop down list. Set the View by to Small icons and then choose Default Programs. To do that: In Windows 7: click the Start menu and then choose Control Panel. The way to choose a default program for a specific type of files, is from Control Panel > Default Programs.
Enable Excel, and click Office button or File tab > Options. Choose a Default Program for specific file types (extensions). To set the default file location in Excel to your Profiles "My Documents", follow these steps:ġ. To change default view in Excel, you need to go to the Excel Options to change its default setting.
It will also address how to set the location of where you want the Excel Reports to be saved when using the Report Manager. This article will address what to do when there is an issue with Excel opening reports run from Prophets Report Manager. Im using Excel 365 and tried the built-in help using the phrase default template directory and got back results that talk a lot about what a template is but no information about how to discover where the default Excel template directory is located, thus this question.