Forum Discussion

Kris9797's avatar
Kris9797
New Member
2 years ago

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

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. 

Need Help

11 Replies

  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    Hi Kris9797 

     

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

    • Kris9797's avatar
      Kris9797
      New Member
      2 years ago

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

      • mlsx4's avatar
        mlsx4
        Memorable Member
        2 years ago

        Hi Kris9797 

         

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

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

     

    --Nate

    • Kris9797's avatar
      Kris9797
      New Member
      2 years ago

      Hi!

      How am I able to do that?

       

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