Leading the way in Microsoft Office Development

What is a Workspace ?

There will be times when you need to work on multiple workbooks at the same time and has the file extension (".xlw").

The term workspace refers to all the open workbooks and their exact screen position and window sizes.

A workspace file does not include the actual workbooks.

There may be times when you need to open workbooks simultaneously.

You can save all the open workbooks as a workspace to be opened another time.

This saves all the open workbooks plus their present location on the screen

The term workspace refers to a group of workbooks inclusing there exact screen position and window size.

SS

You may have a project that uses two or more workbooks and you might want to always have the workbooks arranged in a particular way.

It is possible to save this arrangement as a workspace.

You can then open the workspace at a later date and Excel will display the workbooks exactly as they were saved.

A workspace is the name used to describe the snapshot of your current Excel workbooks. When you save a workspace ??

It is possible to store this configuration and open it as a single file. This will prevent you have to open each individual workbook one after the other.

The configuration of multiple workbooks is called a Workspace.

Saving a Workspace

Open all the workbooks which you want to include in your workspace.

(File > Save Workspace)

SS

use the default file name

If you enter a different name make sure that "Workspaces (".xlw") is selected from the "save as type" drop-down box.

When you save a workspace all the currently open workbooks are saved

The filename that is suggested is "Resume.xlw" although this can obviously be changed.

What is saved in a Workspace ?

A workspace file does not include the actual workbooks.

It only includes references to the workbooks that it needs to recreate the workspace.

This includes the file names and the folder locations.

If you distribute a workspace file to a colleague, make sure they can access all the relevant workbooks.

Things to Remember

The file extension may not always appear. This will depend on your Windows Explorer settings. If you always want your file extensions to be displayed select (Tools > Folder Options)(View tab, "Hide extensions for known file types") and make sure this is not checked.