Excel > Excel 2003 Intermediate > Working with Multiple Workbooks

Workspace Files

If the same set of workbooks are used frequently, they could be saved as a workspace file, saving time opening and arranging them in future.

A workspace file saves all the information about the open workbooks including their screen posiition and window size.

When the workspace is opened, it opens each workbook saved in the workspace and displays them on screen as it was saved. Workbooks that are saved in a workspace file can still be opened and worked on individually.

Before creating a workspace, lets arrange the workbooks on screen so that they are easier to work with.

Arranging workbooks

Excel provides 4 different window arrangement options for working with multiple workbooks. They are Tiled, Horizontal, Vertical and Cascade.

To apply one of these views, click Arrange under the Window menu and select the option you require.

As we are using 3 workbooks, we have decided upon the tiled arrangement.

Creating a workspace file

1. Click File > Save Workspace

The Save Workspace dialogue box is displayed



2. Navigate to the file location that you want to save the workspace
3. Enter a name for the workspace file in the File name field
4. Click Save

Opening a workspace file

1. Click File > Open

The Open dialogue box is displayed

2. Navigate to the location of the workspace file
3. Select the workspace



4. Click Open

Each workbook saved within the workspace will be opened and positioned on screen.

Linking cells Excel file protection

Guides