Kemidan2014
Board Regular
- Joined
- Apr 4, 2022
- Messages
- 226
- Office Version
- 365
- Platform
- Windows
I made a workbook to reference another persons workbook to do some countifs to help with accountability.
When both books are open the formulas update just fine
When i close the source book i get #VALUE! error
1) i know the formulas themselves are calculating correctly when the source workbook is OPEN so its not a formula syntax error
2) the formulas when the SOURCE workbook is CLOSED, Display the correct file path for the source book where it is located
3) My workbook and source workbook are on the same Drive of the Network
4) Confirmed Calculation options are set to Automatic.
What could be other reasons why these externally linked referenced formulas are not updating when the i open my work book but leave the source book closed?
When both books are open the formulas update just fine
When i close the source book i get #VALUE! error
1) i know the formulas themselves are calculating correctly when the source workbook is OPEN so its not a formula syntax error
2) the formulas when the SOURCE workbook is CLOSED, Display the correct file path for the source book where it is located
3) My workbook and source workbook are on the same Drive of the Network
4) Confirmed Calculation options are set to Automatic.
What could be other reasons why these externally linked referenced formulas are not updating when the i open my work book but leave the source book closed?