Get Data from Table/Range grayed out if cursor is in a legit Excel Table Build 1809

Anonymous
2018-08-16T00:36:08+00:00

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.

0 comments

25 answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2018-08-19T18:55:52+00:00

    I have the same problem. I was on Insider Fast and Excel completely crashed. I re-installed everything and now I'm on Monthly Targeted 1808-10730.20030, where Get Data From Table/Range is grayed out when trying to use a pre-existing Excel Table.

    I also note that the new data types , Stock and Geography, are not available in this version, but they should be according to the documentation.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-08-20T16:22:43+00:00

    UGH! You are right. I have a machine with the same monthly targeted build and this is the case, grayed out From Table/Range.

    If you convert it to a range (bad bad idea for many reasons) then the button works.

    It is one thing to do this to insiders, but wholly another to do it to monthly targeted users, which aren't beta testers.

    Kinda irks me a change was made that infected both builds. Isn't that what Insider is for, to test code changes before rolling out to Monthly Targeted, then Monthly, etc?

    Defeats the purpose of Insider IMHO.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-08-20T18:42:05+00:00

    It is even grayed out on the Get Data > From Other Sources menu.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-08-20T23:27:43+00:00

    I have same issue build 1808 10730.20030

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-08-22T19:13:02+00:00

    These issues remain unresolved after an update to 1808-10730.20053.

    Was this answer helpful?

    0 comments