Is it Possible to copy or rename the name of the sheet where the result of a query is in, in Power Query Excel or M

Marc Bergmans 101 Reputation points
2021-02-18T09:00:52.627+00:00

Hello,

Here i am again.
I'm sorry to bother you again, but i'm rather new in Excel Power Query and the work that i have to do in Power Query seems not the normal/easier tasks.

Is it Possible to copy or rename the name of the sheet where the result of a query is in, in a query of Power Query Excel or M

My best regards

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,879 questions
0 comments
Accepted answer
  1. Lz._ 8,991 Reputation points
    2021-02-18T09:43:11.223+00:00

    Hi @Marc Bergmans

    (when you have a moment: you have 2 threads pending feedback/accept as answer => can help others who search the site - Thanks)

    If your question is: is there a way to name/rename (from/using Power Query) the sheet a query output loads to?
    The answer is No. Only way to do this automatically requires VBA

    If question misunderstood let me know
    Cheers

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Marc Bergmans 101 Reputation points
    2021-02-18T16:34:59.603+00:00

    Okay, Thank Yoiu.
    Maybe something to make possible in the next update of Power Query Excel.
    This would make automation which easier.