Normally, Excel starts looking for spreadsheets in the directory in which you started the program. Typically this is your directory. If you want to change the default directory path, you can do so in the following manner:
Figure 1. The General tab of the Options dialog box.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2632) applies to Microsoft Excel 97, 2000, 2002, and 2003.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
If you have some legacy data stored in very old spreadsheet files, you may be wondering how to get that data into an ...
Discover MoreBy using a command-line switch, Excel can be started in safe mode. This means that the program is loaded with bare-bones ...
Discover MoreExcel allows you to control how it uses the Windows Taskbar. This tip explains the two ways Excel can use the Taskbar and ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2015-06-26 16:52:13
BADBOYDANO
FANTASTIC! TNX
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2022 Sharon Parq Associates, Inc.
Comments