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!
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!