How do we suppress duplicate PQ functions?

[Charley]

In Excel, I want to copy a Power Query query that calls a custom PQ function to a different workbook that already has that function. How do I keep PQ from pasting the called function as a second instance of it?

 

[Ken Puls]

Hi Charley,

PQ tries to be too smart when you copy and paste. The only way to work around this is to copy/paste the raw M code (or use my Monkey Tools add-in to inject a query instead.)

 

[Charley]

Okay, Ken. Thanks.