This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
The Get & Transform icon to get data "from a table or range" is grayed out if the cell is in an Excel table. If it is in a non-table area, it converts to a table and loads, but will not let you load from a real table. You have to either load from a different table then change the SOURCE = line in the query, or manually type the = Excel.CurrentWorkbook(){[Name="Table1"]}[Content] statement.
This is Excel 1809 build 10809.20001.
I know for a fact this worked yesterday, and I got this build last night.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
I have the same issue.
One work around:
Get Data > From File > From Workbook > select the same Workbook and desired Table in it as Data Source.
Works for me in the meantime.
However, subscribed, as this is one of the features I use quite frequently...
I have heard from the team that they are aware of this issue and are working to get it resolved. I don't have a timeline to share right now, but will let you know once I have more information.
-Jesse
Thanks. It is moderately frustrating this is affecting insiders.
It is really frustrating that this bug was pushed out to Monthly Targeted users when the insider build of 1808 never had it. It was new in 1809 for insiders.
I have heard from the team that they are aware of this issue and are working to get it resolved. I don't have a timeline to share right now, but will let you know once I have more information.
-Jesse
I have reached out to the Excel team about this issue and will let you know once I have any information to share.
-Jesse
Confirmed here, as well. 1808 10730.20053
Need a solution obviously.