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?