The interesting statement is that the problem does not occur on other computers. This leads to the question of "Why not?"
When a workbook is opened, Excel tries to follow all the links and do its updates. If the links are to a hard drive letter or mapped drive letter (e.g., "E:"), then the mapping must be there or the update will fail and the values will not change. This may explain why it does not change on other workstations.
The next big question is, "If an update is happening, is thiswrong?" In theory, having the update is exactly what you want -- to have the latest information. Is the referenced data wrong, or is it updating from the wrong place?
If the referenced workbooks are already open in Excel, I believe the in-memory version of the workbook is used rather than the disk version. If your user opens all of the other wooksbooks before opening the budget, do the values change, and are they correct after any changes?
One thing I have seen at various clients is the problem of timing, and this may be what is getting you. It goes like this:
My "May Budget" workbook references a workbook called "current inventory" for some reason. What I really wanted was the current inventory workbook frozen as of the end of May, but instead I referenced the real current inventory, which changes by the minute, so my numbers are always changing.
A solution for this is to make multiple directory trees, one for each month, and have references be relative to the tree. At the endof the month, copy the real, working workbooks into the appropriate subdirectories of the month you want to close. Those copies, not being updated, will not keep changing the financials for a past month end.
Good luck.
