Power Query -- When do changes in the query editor get saved?

kkardynalski

New Member
Joined
Jul 11, 2015
Messages
8
I love having the navigation pane in the query editor so I can go back and forth between queries without loading them. However, I've been losing some work from time to time* and it occurs to me to wonder when and how these changes get saved.

If you go in and group and rename queries, do you have to close and load one of them to save the changes?



Kathy

* I guess I can't TOTALLY rule out the possibility that I'm coding in my sleep and just dreaming that I made changes! Who knows? :)
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.
Let's put it like this: One weakness of Power Query currently is that there is no "undo"-button. So the only way to not save your work is to close the whole workbook without saving (and therefore loosing all other work you've done as well).

Sorry, but I think this answers your question :-)
 
Last edited:
Upvote 0
Solution

Forum statistics

Threads
1,223,227
Messages
6,170,848
Members
452,361
Latest member
d3ad3y3

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top