Share via

Unable to Load Power Query table to existing sheet - Excel 1710 build 8613.1000

Anonymous
2017-10-04T18:23:24+00:00

I am unable to load a new Power Query (Get & Transform) to an existing Excel sheet. "Existing Worksheet" is grayed out when "Table" is select at the top. It will only let me load to a new sheet, which is not what I want.

If I click on PivotTable report or Pivot Chart, it will allow me to put it on an existing sheet. I am not sure when this changed as I rarely load to a sheet, but it is extremely inconvenient to force it to a new sheet. I can CUT and PASTE the entire table where I want it, but that is an extra step, including deleting the extra sheet.

Seems like a bug. See image below to see the dialog box has the option grayed out.

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
Answer accepted by question author
  1. Anonymous
    2017-10-09T17:57:30+00:00

    Hi Ed,

    I haven't heard anything, but that's probably the case. Thanks for the update.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-10-04T21:31:38+00:00

    Hi Ed,

    Thank you for the report (especially with the detail). I'll see who we can contact on the product team for this one. Thanks again,

    0 comments
  2. Anonymous
    2017-10-09T17:19:04+00:00

    Jay,

    this works today. I have not upgraded to a newer version (not one available) so I am assuming someone flipped a switch on the backend to enable this again.

    0 comments