Purple Turtle
New Member
- Joined
- Aug 2, 2020
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
I'm having issues with an external referenced cell. The formula for the link looks like =[Workbookname.xlsm]Sheet1!$A$1
The workbooks are both on the same drive. The destination cell will only update when both workbooks are open at the same time.
Is it possible to allow the update to happen when the destination workbook is closed?
The workbooks are both on the same drive. The destination cell will only update when both workbooks are open at the same time.
Is it possible to allow the update to happen when the destination workbook is closed?