BrandonWLH
Board Regular
- Joined
- Jun 14, 2011
- Messages
- 97
I got the references set up and it pulls the data from the other workbooks properly.
The problem I am having is if a user updates on of the child workbooks, the parent workbook doesn't show the updated value.
The parent workbook cells contain the reference formulas linked to the child workbooks. If I retype in the formula and his enter, it grabs the updated value, but using CalculateFull doesn't seem to do the same. Am I missing some simple Application. call to cause it to update all references to other workbooks?
The problem I am having is if a user updates on of the child workbooks, the parent workbook doesn't show the updated value.
The parent workbook cells contain the reference formulas linked to the child workbooks. If I retype in the formula and his enter, it grabs the updated value, but using CalculateFull doesn't seem to do the same. Am I missing some simple Application. call to cause it to update all references to other workbooks?
