Non-updating formulae

  • Thread starter Thread starter GavinB
  • Start date Start date
G

GavinB

Hi,

I'm having trouble with a spreadsheet. I copied the spreadsheet fro
another user (not sure of Excel version) and loaded it onto my pc.
There are a lot of formulae within this spreadsheet, and i've no
discovered that when i change values which should update the formul
output, there is no change. It is as though the original output valu
is frozen in the cell.

If I retype the formula, it works. However, there are so many formula
this is not a realistic solution. And if i retype the formula and the
'fill', the new number is shown in all the cells, regardless of whethe
this is the correct answer or not!

Hopefully that all makes some sense. Is there someway to 'refresh' th
whole spreadsheet, to make the formulae 'active' again?!?!

Thanks
 
Gavin

The recalculate key is F9.

To avoid having to use that you can do Tools | Options, choose the
Calculation tab and click on Automatic in the Calculation section.

David
 
Back
Top