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: Most helpful
Most helpful Newest Oldest
  1. 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.

    Was this answer helpful?

    0 comments
  2. 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

    Was this answer helpful?

    0 comments
  3. 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

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-08-29T14:44:22+00:00

    Confirmed here, as well. 1808 10730.20053

    Need a solution obviously.

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-08-27T21:57:39+00:00

    Same issue for me on 1809.

    Was this answer helpful?

    0 comments