Microsoft KB Archive/48147

From BetaArchive Wiki

Using Paste from One Excel Instance to Another PSS ID Number: Q48147 Article last modified on 06-25-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00


The information in this article applies to:
- Microsoft Excel for Windows, version 2.0, 2.1, 3.0


When running two different instances of Microsoft Excel, Paste operates differently between instances than it does between worksheets.

For example, if you copy a range of data from one spreadsheet to another, Paste can only paste values (no formulas, formatting, etc.) when moving between instances of Microsoft Excel, whereas all information is copied when using Paste between different worksheets in the same instance of Microsoft Excel. Also, Paste Special cannot be invoked when copying from one instance to another because only values can be pasted between instances.

Between macro sheets, formulas can be pasted by choosing Paste Special, and selecting either Text, or CSV. The DIF format will try to paste the formula in, but you may see anomolies such as misplaced quotation marks.

Additional reference words: 2.0 2.00 2.01 2.1 2.10 3.0 3.00

Copyright Microsoft Corporation 1993.