Indirect reference to another workbook when the other workbook is not open

[gberg]

I have "Workbook A" that has formulas with indirect references to another Workbook. They only work with the other Workbook is open. Is there a way to have the indirect formulas work when the other workbook is closed?

Here is an example of one of the formulas:

=SUMIF(INDIRECT("'"&Data_Weekly_Spreadsheet&"'!TBL_JPR[PROJ '#]"),Project_Number,INDIRECT("'"&Data_Weekly_Spreadsheet&"'!TBL_JPR[ESTIMATED LABOR]"))

Data_Weekly_Spreadsheet = Weekly Spreadsheets 2022 - Original.xlsm

"Workbook A" is located in - C:\Users\gberg\OneDrive\AJ - DC Operations\Backlogs
Weekly Spreadsheets 2022 - Original.xlsm is located - C:\Users\gberg\OneDrive\Weekly Spreadsheets

Another example:
=SUMIF(INDIRECT("'"&Data_Job_Log&"'!TBL_Projects[Project '#]"),Project_Number,INDIRECT("'"&Data_Job_Log&"'!TBL_Projects[Pending Labor]"))

Data_Job_Log = Job Log Coins All Jobs- 2022.xlsm


Job Log Coins All Jobs- 2022.xlsm = P:\Job Logs



Thanks for any help!

 

[Fluff]

Is there a way to have the indirect formulas work when the other workbook is closed?

Unfortunately not.

 

[gberg]

I was afraid that was going to be the answer. Thanks

 

[davesexcel]

Some formulas will not work with closed workbooks, this may be one of them.

 

[Fluff]

Glad to help & thanks for the feedback.