Feb 19 2021 07:19 AM
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.
Feb 19 2021 12:36 PM
Solution@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.
Mar 13 2021 10:09 AM
Feb 19 2021 12:36 PM
Solution@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.