Changing Excel Data Default Sub-Directory
Excel's default data sub-directory is My Documents, but this default can be changed to something more meaningful like C:\Excel_Files, etc. Follow these instructions:
- Start button, run Excel, and choose Tools|Options.
- When the Options dialog box opens, click the General Tab.
- Now click in the Default file location entry box and replace the current entry with C:\Excel Files or the path where you will be storing your Excel worksheets.
- Click OK to close the dialog box and save your new selection. Exit Excel and then run it again so that your change will take effect.
Tip comes from Sue Whitehouse and is extracted from Tipworld, visit their website for more tips by clicking on the globe
Just click on the button for the Tiproom's Home Page.