cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
solarpolygon
New Member

Excel.CurrentWorkbook() sees a table that is not visible in the source. Namespace problem?

I have a Source command in a PowerQuery that looks like this:

 

 

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],

 

 

I do not see a table named "Table2" in the Workbook. If I change "Name" to any other table name I know exists in the workbook, I get an error.

When I try to create a new Data Source in another workbook and choose Excel Workbook and then this particular workbook as the data source, it shows me all the tables I know exist, plus this "Table2".

 

It gets weirder. I saved a copy of the original workbook, then deleted the query in the copy. Now queries I believed to be using the original workbook as the data source have stopped working, claiming the source worksheet "Table2" does not exist.

 

What have I misunderstood about the way PowerQuery works?

1 ACCEPTED SOLUTION
Ehren
Microsoft
Microsoft

What do you see if, after opening the workbook that apparently contains the mystery table, you click Formulas -> Name Manager?

View solution in original post

6 REPLIES 6
v-stephen-msft
Community Support
Community Support

Hi @solarpolygon ,

 

You can check your table names in name box:

5.png

 

Reference: Rename an Excel table

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Okay, there I see the table in question. If I select it, Excel jumps to a table that has a different name on the tab. Why is there this difference in the naming?

Maybe you have two names defined for overlapping or identical ranges?

Ehren
Microsoft
Microsoft

What do you see if, after opening the workbook that apparently contains the mystery table, you click Formulas -> Name Manager?

Okay, there I see the "Table2", which refers to a subregion of the Worksheet that excludes the headers.

 

I've been using Excel a long time, but this is the first time I've seen Name Manager. I guess I'd better read up on it 🙂

Hi @solarpolygon ,

 

Maybe you confuse Sheet and Table.😀

When you connect the excel file, you will see the tables and the sheets, and the tables are contained in the sheet.

vstephenmsft_0-1637052223926.png

vstephenmsft_1-1637052294918.png

 

If your problem is solved, please mark the helpful reply as the answer, and more people will benefit.

 

Best Regards,

Stephen Tao

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!