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
marionatdjian
Occasional Contributor

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

@marionatdjian 

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

@marionatdjian 

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

When you have a workbook with lots of worksheets it's very useful to create an Index of All Sheet Names and be able to Navigate to any of these worksheets and back to the Index. There are 3 methods for doing this: Either by Using Functions Or By using a VBA code Or By Using Power Query In this ...
In this tutorial I show you how to create a list of All sheet names in any workbook by using a Macro language function (=Get.Workbook) inside a Defined name. I will then combine the Defined name with an INDEX function, a ROW function, a REPLACE function and an IFERROR function. Then we create a ...
In this tutorial I show you how to create a list of All sheet names in any workbook (including the Hidden Sheets) by using a simple VBA code. I walk you step by step for creating that code. Then we create a Forward and Backward Navigation from the Index of Sheets to any sheet and back, using a ...

@marionatdjian 

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

Starting from Excel 2013 we have a new feature known as Inquire. With Inquire you can analyze, audit and review your workbooks along with data dependencies and potential errors and security concerns. Let's learn about this exciting new feature.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies