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-26T00:18:42+00:00

    yup mine also.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-08-24T19:04:35+00:00

    Please send another with the new build.

    -Jesse

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-08-24T17:20:49+00:00

    Alex, I'll take "Things not fixed in 1809 build 10820.20006"

    ***DAILY DOUBLE****

    :-(

    Should we send more frown faces, or was one enough?

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-08-22T19:39:02+00:00

    Everyone that is experiencing this issue, please report it via the File > Feedback > Send a Frown menu.

    -Jesse

    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