Microsoft KB Archive/29848

Excel: Unable to Copy Formulas and Formatting From Worksheet PSS ID Number: Q29848 Article last modified on 06-25-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00 | 2.20 2.21 3.00 | 3.00

WINDOWS | OS/2 | MACINTOSH

Summary:

When you attempt to copy a range of cells containing formulas and border formatting from a protected worksheet to another sheet, the values of the formulas are carried over, but not the formulas or border formatting.

More Information:

Formulas and border formatting will not transfer when the Options Protect Document command is active.

To copy the formulas and formatting, you must turn the protection off.

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

Copyright Microsoft Corporation 1993.