Microsoft 365 Insider | Excel | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Confirmed here, as well. 1808 10730.20053
Need a solution obviously.
Get Data from Table/Range grayed out if cursor is in a legit Excel Table Build 1809
![](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)
Anonymous
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.
Microsoft 365 Insider | Excel | Windows
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.
25 answers
Sort by: Oldest
-
Anonymous
2018-08-29T14:44:22+00:00 -
Anonymous
2018-08-29T17:50:54+00:00 I have reached out to the Excel team about this issue and will let you know once I have any information to share.
-Jesse
-
Anonymous
2018-08-29T18:04:06+00:00 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
-
Anonymous
2018-08-29T18:06:19+00:00 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.
-
Anonymous
2018-08-30T10:43:00+00:00 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...