How to get copied formulas to work




I have copied formulas from some cells in Excel to another but the values displayed in the new cell are not refreshed and show only values from the copied cells, although the formula copied is correct. How can I get the cells to display the new correct values?

Chances are that Calculation in Excel is set to manual. Go to Tools--Options, choose the Calculation Tab and change it back to automatic, or press F9 to make Excel calculate immediately.

Category: Digital Helpline, Spreadsheet
Issue: Dec 1996
Pages: 178

These Web pages are produced by Australian PC World © 1997 IDG Communications