I have got a budgeting spreadsheets in Excel 2003 as follows:
1) "Data Entry {1-10}" worksheets
2) On each data entry spreadsheets, there is an "aggregate" function, which
is invokable with a click on a Button. The code behind each button on each
of these data entry worksheet is as follows:
2.1) It Set ThisWorkbook.objCurWorkSheet =
Worksheets("currentWorksheetName")
2.2) It invokes ThisWorkbook.processItem
2.2.1) processItem is a workbook level global function that aggregate data
from the current data entry worksheet into a "Overall Operating budget"
worksheet
3) I have 3 seperate "Team operating budget" worksheet that function as
follows (they are intended to be a "view" into the "Overall Operating
budget" worksheet:
3.1) The values are obtained as hyperlinks into the "Overall Operating
Budget" worksheet
For instance cell G19 in "Team1 Operating budget" is set to "='Overall
Operating Budget'!G62"
3.2) "Team{1-3} Operating Budget" worksheets are locked

This has been working fine, but recently the linking seem to stop working
and values no longer seem to be linking to values in "Overall Operating
Budget" worksheet. I have the following observations:
1) Even if I unlock the "Team{1-3}Operating Budget" worksheets, the links
are not updating the value
2) The values are NOT updated when I close and re-open the worksheets
3) The only way the values seems to be updating is if I go into the cells
with linked values in "Team{1-3} Operatin Budget", press F2 to modify cell
(but actually makes no changes), then press ENTER, and the value is
refreshed instantly
4) If I make further changes in "Data Entry {1-10}", pressed the Aggregate
button to update values in the "Overall Operating Budget" worksheet which
change the value that the updated cell of 3 above is linked into, then the
value in the cell updated at 3 above does not change until I repeat step 3!!

How is this possible and how could I fix this?