why won't my excel spreadsheet formulas update when I copy them?

P

Pete_UK

A little more detail would help, but perhaps you have absolute
addresses in the formula, so they will always calculate to the same
value. Perhaps your worksheet is set to Manual Calculation mode (click
on Tools | Options | Calculation tab to change it). Or maybe the cell
is formatted as text - format the cell(s) as General, then F2 followed
by <Enter> to change them.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell showing formula instead of date 6
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
Excel - Not calculating formulas 1
Excel Formula displays text of formula 2
Formula shows in cell instead of results (text reference) 5
Macro or Look-up? 1
Formulas Won't Auto Calc 1
Deleting worksheet breaks my formulas 3

Top