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
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