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-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

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-08-16T18:00:54+00:00

    Will do. Thanks Jesse.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-08-17T00:26:15+00:00

    FWIW - not just me seeing this. Hope it is fixed soon.

    Was this answer helpful?

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

    Was this answer helpful?

    0 comments
  5. Anonymous
    2018-08-17T22:55:16+00:00

    This table/data bug is notfixed in 1809 build 10813.20004

    Was this answer helpful?

    0 comments