Help with power query

[djmaccrea]

Hello,

New to the forum. I'm having issues with query updates. I've created a query and moved things around a bit, added new columns and rows for totals and titles but now if I update the query it erases all of the changes and formatting I made outside of the query and just displays the original query data. Is there a way to lock/freeze a selection of cells so they won't be affected by the query update? Alternatively, is there a way to only update certain query values at a time? I can provide files or screenshots if necessary. Thank you!

 

[VBA Geek]

Hi dj,

that is not possible to do. Every time you update a query the whole table is refreshed, which I think is a great thing!

 

[djmaccrea]

Ok, in that case is there a better way to retrieve data from a separate workbook automatically? In my example as a brewer I'm trying to use a query to gather raw material costs from one workbook and use our brew sheets to calculate totals. Yet, since I made a bunch of changes to the format of the table, if the query is updated, the whole thing becomes unusable. Any help is sincerely appreciated, thank you!

 

[VBA Geek]

Hi dj, yes you can have another workbook file as the source of your query