Forum Discussion
Is it possible to use a cell value for a workbook reference?
Been churning through a project for work and I’m missing one piece. If I have a workbook name 010203 and i link it, it displays as: ’[010203.xlsx]Sheet1’!$A$1 If I have another workbook and ...
You can use INDIRECT, but please note that it will only work if the workbook referred to is open in Excel too.
=INDIRECT("'[" & B1 & ".xlsx]Sheet1'!A1")
Thank you! Is there any workaround to needing the workbook open, or is that a different beast?
Not with a formula. Perhaps it's possible using PowerQuery, but I'm not an expert on that.
