coping formulas from one cell to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason when I copy a formula from one cell to another it copies the
formula, but also the value that was in the copied cell. I had no problem
with this before on this spreadsheet
 
Probably you're calculation is set to manual, or you have another workbook
open whose calculation is set to manual, or it just hadn't had enough time
to update the cells yet (the case when many, many rows).
************
Anne Troy
www.OfficeArticles.com
 
I think you got it Anne. :)

Fyi, if you hit F9 and it updates, pretty sure that's the problem.
 
Back
Top