Microsoft 365 Insider | Excel | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
This table/data bug is notfixed in 1809 build 10813.20004
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: Newest
-
Anonymous
2018-08-17T22:55:16+00:00 -
Anonymous
2018-08-17T08:07:05+00:00 Thank you for the report. Let us know if the issue still occurs after the next build is available, hopefully by the end of this week.
-Jesse
I have the same problem, would be nice if you could update this thread when the bug i solved.
Thanks,
Tobias
-
Anonymous
2018-08-16T18:00:54+00:00 Will do. Thanks Jesse.
-
Anonymous
2018-08-16T17:00:06+00:00 Thank you for the report. Let us know if the issue still occurs after the next build is available, hopefully by the end of this week.
-Jesse