Forum Discussion
How to control a workbook reference (file path) with a cell
So I have a master workbook that has multiple sheets referenced to multiple work books. I want to modified the file paths in the workbook references with cell input on the master workbook. So an examp...
yes true indirect will work in your case
- Even while having the referenced workbooks closed? Also where would I put the function? I tried placing it at the front and In the locations that I want the file path variable to be without anything other than !ref. Even with the other workbook open.
