I have a summary sheet on worksheet A and it brings in figures from the
various pages in the same workbook. If I am on a particular page and add or
change figures my total is ok, but when I go to the summary page, it is not
updating that cell reference unless I edit with F2 then press enter. I have
tried to recalc with F9 but this has no effect.

What can I do?