Quickly Open a Set of Excel Files

Do you have a few Excel files that you usually have open all at the same time? Maybe the files are linked, and you update one and check the results in the other file. Or maybe there are a few files that you open first thing every morning, to enter or update the data.
After you open the files, you might spend a minute or two arranging the files so you can see everything as you work. Then you make the changes, close everything, and do the same thing again tomorrow.

Save Time With a Workspace

To save time, you can use Excel’s Save Workspace feature. It remembers which files are open, how you have them arranged, and where the files are located. The Workspace file doesn’t contain the files themselves. You’ll still be able to open the files individually, and use the Workspace file when you want to open them together.

Prepare the Files

  1. Open all the files that you want to use.
  2. Arrange the files any way you’d like (Tiled, Vertical, etc.)

Create a Workspace File

In Excel 2007 / 2010, click Save Workspace, on the Ribbon’s View tab.
In Excel 2003, click the File menu, then click Save Workspace.
Type a name for the Workspace file, and click OK. The xlw extension will be automatically added to the file name.

Close a Workspace File

In Excel 2003, hold the Shift key, click the File menu, and click Close All.
In Excel 2007, close each file individually, or add the Close All command to the Quick Access Toolbar. Or, to close all the files, and Excel, hold the Shift key, and click the X at the top right of the Excel window.

Open a Workspace File

Open a Workspace File, just as you would open any other Excel File. Click the Open button, select the Workspace file, and click Open.