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.
Yesterday, I did unistall Office and install it again - and the problem was solved for me. After installation I now have 1808-10730.20088 and it is working again :-)
Have discovered problem also impacts simply double-clicking on a Query in order to edit it. Won't work. However right-clicking the query from side panel does.
In event that a query has error(s), clicking on the link to the query containing errors (derivative query) does not work either. Requires Task Manager in order to exit.
This appears to be fixed in insider 1809 build 10823.20000.
My machines on 1808 Monthly Targeted still broken, and no update is being reported. Hopefully that one will be available soon.
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...
Interesting. Note though that will only work if the file is on a normal file system - local hard drive, network drive. it will not work if the file is on Sharepoint as most of our files are, unless the user is syncing that library locally. If your file is on a local file system, certainly easier than my solution.
For now, I've just been:
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...