I am working on an excel file with multiple tabs and tables. There is no more than one table per tab. Some table are data I have copy/paste, some others are tables that I have created and contain formulas linked to my data tables.
So the thing is, I wanted to update my data and copy/paste my new numbers in a table named "BDD_UnitSoldSTD" on a tab named "BDD Unit Sold STD" however I was not able to find this tab.
I though someone deleted it by mistake so I decide to create a new one named the same so my formulas would linked immediatly without me having to update all formulas. But when I enter "BDD_UnitSoldSTD" as my table name, Excel is telling me that "this name already exist. Names must be unique" so the tab must be still exist somewhere...
I have looked everywhere, it is not on my hidden tabs, and the case "show all tabs" in the "options" menu is checked. I have also double checked all my table's name and no one have this name.
I don't know where it could be, do you know where I could look ?
you have another option as well if my previous techniques don't get you an answer.
1- Add the INQUIRE Tab to the Ribbon: File >> Options >> ADD Ins >> Manage (lower Left corner) >> Select COM Addins (from the Drop List) >> Go >> Check the Box for INQUIRE >> OK >> It will be added to the Ribbon
2- Let's use it in Analyzing the workbook:
Click on the INQUIRE Tab of the Ribbon >> Click "Workbook Analysis" to the very Left (File should be saved first) >> in the Window that opens >> Under Items Check "Workbook" & Check " Ranges" >. Then Click on Export To Excel >> It will create a report that tells you if what you are looking for Exists or Not & Where it is.