Linked Cells

Hi 

if i have a formula in cells and i change a specific cell its not changing the cells that would be affected by it unless i click into the cell then press enter. 

 

This has only recently happened and its happening with all my excel documents old or new formula’s

 

for example if i have the formula in cell A3

A3= A1*A2

if i then went and changed A2’s data it would not up date cell A3 and that would stay as the previous total unless i went into the cell and pressed enter. 

By: liam davies

One thought on “Linked Cells

  1. andrew walker Post author

    Have you checked to make sure that automatic calculation has not been switched off?

Leave a Reply

Your email address will not be published. Required fields are marked *