Hi All -

I've been researching this question for a while now and all roads are leading to "not possible without VBA" but is there way to reference a closed Workbook dynamically in Excel 2016? The Stack Overflow posts are 3 to 8 years old so hopefully something has changed.

By dynamic, I want to store the path and file name in cells and then reference them in the formula

This formula works, but obviously not dynamic :
'C:\Users\administrator\[Master_Hours_Template_Client.xlsm]P7'!$D$31
I will use VBA if I have to, but trying to do this via formulas instead. Any tips or links is greatly appreciated! Thank you!