Missing table - How is this even possible?

[rizzo93]

I have a formula that references a table inside the file I'm working in, but I don't see the table in the Name Manager.

All filters have been cleared. How is this even possible? I thought all tables were referenced in Name Manager.

 

[Norie]

Is it possible the table has an external source?

 

[rizzo93]

Is it possible the table has an external source?

That was my first thought, but the formula has no reference to anything outside of the file. It just shows a name of the table and a column within it, not a path to a table.

 

[Fluff]

Check for hidden, or very hidden sheets

 

[rizzo93]

Check for hidden, or very hidden sheets

Thanks, Fluff. What are "very hidden" sheets?

 

[Fluff]

Have a look at this https://www.ablebits.com/office-addins-blog/2017/12/20/very-hidden-sheets-excel/