Stumped Trying to Find a Table Referenced by Pivot Table

[Elfear73]

I inherited a report from a colleague who passed away recently and I've hit a roadblock while trying to update the data. The report has quite a few pivot tables and a good portion of them reference a table or worksheet called "All_Data". Problem is I can't find the table anywhere.

The workbook is called "Dashboard_SEP_04_Publish.xlsm" and when I check the pivot table data source, it references the same workbook and the mystery table/tab:

Error when refreshing pivot table data

"Can't open PivotTable source file 'C:\Users\User_Name\[Dashboard_SEP_04_Publish.xlsm]All_Data' "


The table does not appear in the list of tables:

Nor is it amongst any of the worksheets in the workbook (hidden or visible). There are also no active Connections in the workbook.

Any idea how to find this table/worksheet?

 

[ExcelToDAX]

Check Name Manager and see if they named a specific range All_Data

 

[Elfear73]

That's a great thought. Unfortunately, there isn't anything by that name in Name Manager. :/

 

[Elfear73]

I think I figured it out. My colleague published a 2nd report that was cutdown from the original since it was so large. I was able to find the original report and it has the All_Data worksheet.