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...
Need Help
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

Kris9797's avatar
Kris9797
New Member
2 years ago

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

  • mlsx4's avatar
    mlsx4
    Memorable Member
    2 years ago

    Inside Excel: Formulas tab > click Name Manager.

    And see if there's something there

    • Kris9797's avatar
      Kris9797
      New Member
      2 years ago

      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's avatar
        mlsx4
        Memorable Member
        2 years ago

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