Power query - connecting to a share point excel file but not seeing some of the tables in that file

[MartyCollins]

As per heading- I have connected to an excel file on share point, I am not seeing all the tables though that are in that file. I am only interested in one particular table and if I navigate to another table and overwrite the table name with the one I want it still doesn’t pick it up.
It’s showing me some tables, all sheets, print ranges, named ranges but missing a few tables - I’m flummoxed!

Thanks
Marty.

 

[ExcelToDAX]

Is it actually a table, or just values in a sheet? Try going to sheet name and looking for the values.

 

[MartyCollins]

It’s a table— think it’s a problem with the file as I have no bother finding tables in other files on sharepoint.
It’s a very complex spreadsheet and gets thousands of hits so don’t fancy rebuilding it just to get this to work.