Overview
I have setup a formula to bring values in from an external workbook using the INDIRECT excel function.
Formula: INDIRECT("'["&C1&"]"&C2&"'!"&C3)
C1= Workbook Name
C2= Sheet Name
C3= Cell Reference
The above formula is applied over 1,000 cells and linking in over 10 workbooks
Issue
There is no issue with the formula; happy with the result
The issue is that for the values to be visibile in the target workbook(not "#ref"), the target workbook must be open.
Is there anyway to store the values in the target workbook without having over 10 source workbooks open?