goofy78270
Well-known Member
- Joined
- May 16, 2007
- Messages
- 555
I have a macro in workbook A that updates workbooks B and C. Workbook A has formulas written which use values from workbooks B and C.
The problem I have is that when I update information in workbooks B and C, the formulas in Workbook A do not update unless I open workbooks B and C or close and reopen workbook A. I have tried to manually calculate using F9 and within the Macro with no luck.
Other than opening these other workbooks, is there a step I seem to be missing?
The problem I have is that when I update information in workbooks B and C, the formulas in Workbook A do not update unless I open workbooks B and C or close and reopen workbook A. I have tried to manually calculate using F9 and within the Macro with no luck.
Other than opening these other workbooks, is there a step I seem to be missing?