Microsoft KB Archive/61074

= Works: Copying Cell Contents from Spreadsheets and Databases =

Article ID: 61074

Article Last Modified on 11/16/2006

-

APPLIES TO


 * Microsoft Works 2.0 Standard Edition
 * Microsoft Works 3.0 Standard Edition
 * Microsoft Works 4.5 Standard Edition
 * Microsoft Works 4.5a
 * Microsoft Works 4.0 Standard Edition
 * Microsoft Works 4.0a

-



This article was previously published under Q61074



SUMMARY
When a cell formula is copied from one spreadsheet to another, the formula is copied, but the value may be different.

The new spreadsheet will try to calculate the value using the new cell references (relative or absolute) of the copied formula.

If a cell from a spreadsheet is copied into a word processor or database file, the value of that cell is copied, but the formula is not copied.

When you copy a cell containing a formula from a field in the database, the value of that cell always gets copied, but the formula does not get copied. For additional information, please see the following article in the Microsoft Knowledge Base:

60683 Works: Copying Formulas in the Database

Additional query words: 2.00 3.00 4.00 4.00a 4.50 4.50a w_works

Keywords: kbinfo KB61074

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.