Excel: Save As Doesn't Build Another Copy of Workbook Document

Last reviewed: November 29, 1994
Article ID: Q89743
The information in this article applies to:
  • Microsoft Excel for Windows, version 4.0
  • Microsoft Excel for the Macintosh, version 4.0

SUMMARY

When using Save As from the File menu in Microsoft Excel to save a new copy of a workbook document, the original document name is not maintained in the workbook. The original document remains, however, with the new name.

MORE INFORMATION

Sometimes it may be necessary to save another copy of a document already in the workbook back to the workbook with another name. Using the Save As command from the File menu changes the name of the document, but does not retain the copy of the document with the original name.

To Save a Workbook Document to Another Name

  1. Open the workbook and choose the Contents button at the bottom of the workbook window.

  2. Select the document that needs to be saved back with a different name.

  3. If the document is bound, change the document to Unbound, activate it, and save the document by choosing File Save. Choose the Contents button.

  4. Select the document that needs to be saved back with a different name, choose the Options button at the bottom of the workbook window and change the name of the document to the new name desired.

  5. Choose the Add button at the bottom of the workbook window.

  6. From the Add dialog box, choose Open and select the original document, then choose OK.

  7. Select the original document name (which now should be in the workbook as bound).

If the documents need to be unbound, choose the Options button at the bottom of the workbook window and change "Store document in" to "Separate file" and delete the unbound copy by choosing Delete from the File menu and selecting the file.

REFERENCES

"Microsoft Excel User's Guide 1," version 4.0, pages 67-78


KBCategory: kbusage
KBSubcategory:

Additional reference words: 4.00 4.0 work book save-as rename re-name
changing build


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 29, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.