Home

Impossible to find an existing table

%3CLINGO-SUB%20id%3D%22lingo-sub-754675%22%20slang%3D%22en-US%22%3EImpossible%20to%20find%20an%20existing%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754675%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20working%20on%20an%20excel%20file%20with%20multiple%20tabs%20and%20tables.%20There%20is%20no%20more%20than%20one%20table%20per%20tab.%20Some%20table%20are%20data%20I%20have%20copy%2Fpaste%2C%20some%20others%20are%20tables%20that%20I%20have%20created%20and%20contain%20formulas%20linked%20to%20my%20data%20tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20the%20thing%20is%2C%20I%20wanted%20to%20update%20my%20data%20and%20copy%2Fpaste%20my%20new%20numbers%20in%20a%20table%20named%20%22BDD_UnitSoldSTD%22%20on%20a%20tab%20named%20%22BDD%20Unit%20Sold%20STD%22%20however%20I%20was%20not%20able%20to%20find%20this%20tab.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20though%20someone%20deleted%20it%20by%20mistake%20so%20I%20decide%20to%20create%20a%20new%20one%20named%20the%20same%20so%20my%20formulas%20would%20linked%20immediatly%20without%20me%20having%20to%20update%20all%20formulas.%20But%20when%20I%20enter%26nbsp%3B%22BDD_UnitSoldSTD%22%20as%20my%20table%20name%2C%20Excel%20is%20telling%20me%20that%20%22this%20name%20already%20exist.%20Names%20must%20be%20unique%22%20so%20the%20tab%20must%20be%20still%20exist%20somewhere...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20looked%20everywhere%2C%20it%20is%20not%20on%20my%20hidden%20tabs%2C%20and%20the%20case%20%22show%20all%20tabs%22%20in%20the%20%22options%22%20menu%20is%20checked.%20I%20have%20also%20double%20checked%20all%20my%20table's%20name%20and%20no%20one%20have%20this%20name.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20know%20where%20it%20could%20be%2C%20do%20you%20know%20where%20I%20could%20look%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%3C%2FP%3E%3CP%3EMarion%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-754675%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754829%22%20slang%3D%22en-US%22%3ERe%3A%20Impossible%20to%20find%20an%20existing%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754829%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366218%22%20target%3D%22_blank%22%3E%40marionatdjian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EMarion%2C%20check%20Formulas-%26gt%3BName%20Manager%2C%20it%20shall%20show%20there%20is%20the%20table.%20Or%20in%20Address%20Bar%20(top%20left%20corner)%20enter%20the%20table%20name%2C%20you%20will%20be%20forward%20on%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754842%22%20slang%3D%22en-US%22%3ERe%3A%20Impossible%20to%20find%20an%20existing%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754842%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366218%22%20target%3D%22_blank%22%3E%40marionatdjian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ELet's%20differentiate%20between%20Sheet%20Tab%20names%20%26amp%3B%20Tables%20(who%20have%20names%20as%20well.%3C%2FP%3E%3CP%3EIf%20you%20are%20looking%20at%20a%20Specific%20Table%20and%20you%20do%20not%20find%20it%2C%20you%20can%20see%20a%20list%20of%20All%20Tables%20by%20clicking%20on%20the%20Formulas%20Tab%20%26gt%3B%26gt%3B%20Name%20Manager%20(Shortcut%20CTRL%20%2B%20F3)%3C%2FP%3E%3CP%3EIf%20you%20are%20looking%20at%20sheet%20tabs%20then%20you%20can%20do%20one%20of%20the%20foollowing%3A%3C%2FP%3E%3CP%3E1-%20To%20the%20far%20left%20side%20of%20the%20sheet%20tabs%20%26gt%3B%26gt%3B%20Right%20click%20on%20the%20Navigation%20buttons%20%26gt%3B%26gt%3B%20You%20get%20a%20List%20of%20All%20the%26nbsp%3B%20VISIBLE%20sheet%20Tabs%20%26gt%3B%26gt%3B%20double%20clicking%20on%20anyone%20of%20them%20%26gt%3B.%20will%20take%20you%20right%20there.%3C%2FP%3E%3CP%3E2-%20You%20can%20extract%20a%20list%20of%20ALL%20Sheet%20VISIBLE%20%26amp%3B%20HIDDEN%20in%20a%20new%20worksheet%20(and%20even%20create%20a%202%20ways%20navigation)%2C%20either%20by%20using%20Power%20Query%20or%20by%20Using%20VBA%26nbsp%3B.%3C%2FP%3E%3CP%3Ei%20explained%20that%20in%202%20separate%20Tutorials%20%2C%20here%20are%20the%20links%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DjEr3uj1ljQ8%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DjEr3uj1ljQ8%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DV0KfbMZa_pY%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DV0KfbMZa_pY%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20also%20do%20it%20by%20using%20formulas%20and%20Functions%20which%20will%20only%20extract%20a%20List%20of%20the%20VISIBLE%20Sheets.%20Here%20is%20another%20Tutorial%20on%20how%20to%20do%20that%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFeKgWSD8IWc%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DFeKgWSD8IWc%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-754875%22%20slang%3D%22en-US%22%3ERe%3A%20Impossible%20to%20find%20an%20existing%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-754875%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F366218%22%20target%3D%22_blank%22%3E%40marionatdjian%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20have%20another%20option%20as%20well%20if%20my%20previous%20techniques%20don't%20get%20you%20an%20answer.%26nbsp%3B%3C%2FP%3E%3CP%3E1-%20Add%20the%20INQUIRE%20Tab%20to%20the%20Ribbon%3A%3CBR%20%2F%3EFile%20%26gt%3B%26gt%3B%20Options%20%26gt%3B%26gt%3B%20ADD%20Ins%20%26gt%3B%26gt%3B%20Manage%20(lower%26nbsp%3B%20Left%20corner)%20%26gt%3B%26gt%3B%20Select%20COM%20Addins%20(from%20the%20Drop%20List)%20%26gt%3B%26gt%3B%20Go%20%26gt%3B%26gt%3B%20Check%20the%20Box%20for%20INQUIRE%20%26gt%3B%26gt%3B%26nbsp%3B%20OK%20%26gt%3B%26gt%3B%26nbsp%3B%20It%20will%20be%20added%20to%20the%20Ribbon%3C%2FP%3E%3CP%3E2-%20Let's%20use%20it%20in%20Analyzing%20the%26nbsp%3B%20workbook%3A%3C%2FP%3E%3CP%3EClick%20on%20the%20INQUIRE%20Tab%20of%20the%20Ribbon%20%26gt%3B%26gt%3B%20Click%20%22Workbook%20Analysis%22%20to%20the%20very%20Left%20(File%20should%20be%20saved%20first)%20%26gt%3B%26gt%3B%20in%20the%20Window%20that%20opens%20%26gt%3B%26gt%3B%20Under%20Items%20Check%20%22Workbook%22%20%26amp%3B%20Check%20%22%20Ranges%22%20%26gt%3B.%20Then%20Click%20on%20Export%20To%20Excel%20%26gt%3B%26gt%3B%20It%20will%20create%20a%20report%20that%20tells%20you%20if%20what%20you%20are%20looking%20for%20Exists%20or%20Not%20%26amp%3B%20Where%20it%20is.%3C%2FP%3E%3CP%3EI%20have%20a%20Tutorial%20on%20using%20the%20Inquire%20Tab%3A%3C%2FP%3E%3CP%3EHere%20is%20the%20Link%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DyOHJJcXtQq4%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DyOHJJcXtQq4%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Deleted
Not applicable

Hi everyone,

 

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 ?

 

Many thanks,

Marion

 

3 Replies

@Deleted 

Marion, check Formulas->Name Manager, it shall show there is the table. Or in Address Bar (top left corner) enter the table name, you will be forward on it.

Highlighted

@Deleted 

Hi,

Let's differentiate between Sheet Tab names & Tables (who have names as well.

If you are looking at a Specific Table and you do not find it, you can see a list of All Tables by clicking on the Formulas Tab >> Name Manager (Shortcut CTRL + F3)

If you are looking at sheet tabs then you can do one of the foollowing:

1- To the far left side of the sheet tabs >> Right click on the Navigation buttons >> You get a List of All the  VISIBLE sheet Tabs >> double clicking on anyone of them >. will take you right there.

2- You can extract a list of ALL Sheet VISIBLE & HIDDEN in a new worksheet (and even create a 2 ways navigation), either by using Power Query or by Using VBA .

i explained that in 2 separate Tutorials , here are the links:
https://www.youtube.com/watch?v=jEr3uj1ljQ8

 

https://www.youtube.com/watch?v=V0KfbMZa_pY

 

You can also do it by using formulas and Functions which will only extract a List of the VISIBLE Sheets. Here is another Tutorial on how to do that:

https://www.youtube.com/watch?v=FeKgWSD8IWc

 

Hope that helps

Nabil Mourad

@Deleted 

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.

I have a Tutorial on using the Inquire Tab:

Here is the Link:

https://www.youtube.com/watch?v=yOHJJcXtQq4

 

Hope that helps

Nabil Mourad

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies