No Automatic Close for an Excel Workspace

Last reviewed: November 4, 1994
Article ID: Q62722

SUMMARY

There is no way to automatically close a workspace group of files in Excel and save any changes to the workspace. Excel will automatically open all the files in a workspace, but to close the workspace, each file must be closed individually.

A workspace file lists the names of documents that are open in the workspace when the workspace file is saved and lists the size and position of the open documents. A workspace file is actually a list of documents, not the documents themselves. You can instruct Excel to close all of the open documents by pressing SHIFT+ALT and choosing Close All from the File menu. This key combination will not save changes to the workspace.

REFERENCES

"Microsoft Excel Reference Guide," version 2.x, pages 724-726

"Microsoft Excel User's Guide," version 3.0, pages 551-552

Additional reference words: 2.00 2.0 2.01 2.1 2.10 2.2 2.21 2.20
3.00 3.0

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.