Copying Formulas Between Two Instances of Excel: Pastes Values

 Last reviewed: November 3, 1994
Article ID: Q68515
The information in this article applies to:
  • Microsoft Excel for Windows, version 2.x, 3.0, 4.0, 4.0a, 5.0

SUMMARY

If you copy a formula from one instance of Microsoft Excel to a sheet in another instance of Microsoft Excel, only the values are pasted; the formulas will be lost. You cannot work around this by using the Paste Special command because that option will be grayed.

Note: copying from and to macro sheets can be accomplished by choosing Paste Special and choosing DIF, Text or CSV from the Data Types listed.

MORE INFORMATION

You can work around this by copying the contents of the of cell as displayed in the Formula Bar, and then pasting it into the second instance. The procedure is:

  1. Move the cursor to the cell that you wish to copy.

  2. Select the contents in the Formula Bar using F2, <CTRL> 

        <SHIFT><HOME>

  3. Select EDIT/COPY, press ESC

  4. Switch to the second instance of Excel.

  5. Select EDIT/PASTE

KBCategory: kbusage
KBSubcategory:

Additional reference words: 5.00 2.0 2.00 2.01 2.1 2.10 3.0 3.00 4.0 4.00

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