Tables still exist when i use =Excel.Currentworkbook() despite deleting all sheets.

[Kris9797]

As the title suggest, I am working on a workbook that is owned by someone else, therefore I am trying to understand how he/she did it.

I tried to delete all the sheets on the workbook, but when I run =Excel.CurrentWorkbook() it still shows some tables.

How do I locate these tables? and what are the possible source that the tables come from other than being tables inside the workbook. 

[Anonymous]

Did you try clearing the cash via the Query options tab?

--Nate

[Kris9797]

Hi!

How am I able to do that?

and I have always assumed that deleting sheets == removing everything related to it

[mlsx4]

Hi @Kris9797 

I'm not really sure, but they can be named ranges defined or printing areas that were also named.

[Kris9797]

i see, but i have deleted all sheets, if it range or printing areas then it should not appear when i query it?

[AlienSx]

@Kris9797 hidden sheets?

[Kris9797]

tried that! no luck 😞

[mlsx4]

Hi @Kris9797 

I don't think so. If ranges are applied for all the workbook, it won't be deleted with the sheet

[Kris9797]

oh okay, how do i go about on looking up the ranges?

[mlsx4]

Inside Excel: Formulas tab > click Name Manager.

And see if there's something there

[Kris9797]

tried that as well, have some weird tables but is not the one i wanted and the tables can't be looked up as well, not sure how they did it

[mlsx4]

Excel also has Power Query. Have you checked there? Just in case, it is using some queries