A BETTER WAY
In the January issue (page 82), I suggested an automatic way to open a group of Excel worksheets in just a few steps—a technique that is especially handy when you need to regularly reopen that group in the future. Several readers suggested a much better way to perform that task, applying Excel’s Save Workspace function
To use Save Workspace in Excel 2003, first open the files you want in the group and then click on File, Save Workspace (see screenshot below) and give it a name (it will automatically be given a .xlw extension).
If you wish, you can customize the setup before you save the file so that selected worksheets within each file will open, or you can even customize it further by having several sections of worksheets all open and arranged on one screen. To do that, click on Window, New Window and Arrange, which brings up this screen:
You can arrange the worksheet layout in a way that lets you easily access just the data you need, as illustrated in the following screenshot:
Excel 2007 also has the Save Workspace function and, as expected, it’s accessed differently. Open the target files and then go to the Ribbon and click on View to access both New Windows (so you can display more than one worksheet) and Arrange All (to customize the display). The Save Workspace icon is farther to the right.
Since there is no limit to the number of Save Workspace files you can store, you may want to establish one for each client or business category.