Is it possible to calculate formulas in a workbook from data in another workbook opened in a separate instance? Purpose: I have multiple workbooks which contain weekly data that is compiled in a separate workbook with a tab for each week. My boss wants to have the data books open on one screen and the analysis book open on another screen. My problem is the formulas are not calculating across instances.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Calculating Formulas from multiple instances of Excel
- Thread starter cQQker
- Start date
