Forum Discussion
Linked formulas across books
Have linked formulas from one excel book to another but the formulas only calculate when the other book is open. How to fix so that it will automatically calculate without the other book being open? The sheet is set to automatically calculate.
Tim_B50 All values in the sheet with linked values show as #value. When the linked sheet is opened, these values magically populate with the proper values. If I close the linked sheet, the values remain. However, when the sheet is saved and re-opened, the values have returned to #value. I'm lost on this one.
2 Replies
- Linked formula used was =SUMIF(....) which does not work across Excel Workbooks unless both books are open. Changed reference to =sumproduct(....) and now works as designed.
Tim_B50 All values in the sheet with linked values show as #value. When the linked sheet is opened, these values magically populate with the proper values. If I close the linked sheet, the values remain. However, when the sheet is saved and re-opened, the values have returned to #value. I'm lost on this one.