editing a PQ, got "This won't work because it would move cells in a table on your worksheet"

[lezawang]

Hi
I have a table which has 3 columns. I created a PowerQ to then merged 2 columns. I loaded the new table back to excel sheet using "Close and Load to.."-->Existing table.
Then I decided to change/edit the name of a column, so I edited the name of a column in Power Q editor and then when click on Close and Load drop down arrow,

1) I only see "Close and Load" the other option "Close & Load to.. " option is grayed out ? Why is that?
2) When I clicked on "Close & Load", I got this error message: "This won't work because it would move cells in a table on your worksheet" Why is that

I just found that, if I "Load & Close" the PowerQ and let excel put it in a seprate sheet, then if I edit the PQ the then "Close & Load" I wont get that
error message but I also still can not select : "Close & Load To..." options

Thank you so much.

 

[Momentman]

Thank you very much for your reply. Close and Load to --> Connection is grayed out. I can not select that option. Only Close&Load is available. Thank you.

Once you load once from PQ, "Close and load to" becomes greyed out. The workaround to at least get to load to a different location or o choose a different option is how @alansidman describes it