Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Did you try clearing the cash via the Query options tab?
--Nate
Hi!
How am I able to do that?
and I have always assumed that deleting sheets == removing everything related to it
Hi @Kris9797
I'm not really sure, but they can be named ranges defined or printing areas that were also named.
i see, but i have deleted all sheets, if it range or printing areas then it should not appear when i query it?
tried that! no luck 😞
Hi @Kris9797
I don't think so. If ranges are applied for all the workbook, it won't be deleted with the sheet
oh okay, how do i go about on looking up the ranges?
Inside Excel: Formulas tab > click Name Manager.
And see if there's something there
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
Excel also has Power Query. Have you checked there? Just in case, it is using some queries