I have a workbook which uses a sum to check the balance on a list of figures.
The sum adds together cells from other workbooks in various locations. When
the file is opened the values brought back by the sum are incorrect. The
only way to correct them is F2 & enter. F9 does not work.

Help....