Hello all,
I have a workbook with the source data needed to create a pivot table.
The pivot table must be in a separate workbook.
My issue is that the source workbook name changes daily with date in file name. (example: Production Report - 20-Jun-23.xlsb)
The pivot table works fine as long as the Production Report file name doesn't change however, it changes daily (example: Production Report - 21-Jun-23.xlsb)
Is there a workaround for this?
I have a workbook with the source data needed to create a pivot table.
The pivot table must be in a separate workbook.
My issue is that the source workbook name changes daily with date in file name. (example: Production Report - 20-Jun-23.xlsb)
The pivot table works fine as long as the Production Report file name doesn't change however, it changes daily (example: Production Report - 21-Jun-23.xlsb)
Is there a workaround for this?