Written by Allen Wyatt (last updated April 11, 2020)
This tip applies to Excel 97, 2000, 2002, and 2003
If you work with multiple workbooks at the same time, you know that traversing folder (directory) paths in the Open dialog box can be tedious. For instance, let's assume you have a workbook you are working on. You open a second workbook, this one in a different directory. (You find it and open it after clicking your way to it in the Open dialog box.)
Now it comes time to open a third workbook. When you display the Open dialog box, Excel assumes you want to start from where you opened the previous workbook. What if you want to actually open it from the same directory in which the first workbook was located? Of course, you can again use the Open dialog box to traverse back to the original directory. An easier method may be to do the following:
Now when you use the Open dialog box, Excel starts in the folder you were last in, which was the one displayed in step 2—the one you want.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3252) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Jumping Around Folders.
Program Successfully in Excel! John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. With this comprehensive guide, "Mr. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Check out Excel 2013 Power Programming with VBA today!
Open a workbook that someone else is working on, and you won't be able to save your changes back into the same file. ...
Discover MoreThe data stored in a worksheet can often correspond to information external to that worksheet. For instance, you might ...
Discover MoreTracking down a problem that occurs with a single workbook can be vexing. One such problem occurred with Chris, and these ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
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 © 2023 Sharon Parq Associates, Inc.
Comments