Manually inputted and edited data in output spreadsheet is deleted or reverts back to source spreadsheet on Data Refresh

Quor

New Member
Joined
Jan 25, 2023
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hello, I am using Excel Power Query.
I have PowerAutomate process that inserts new rows into a Master Spreadsheet.
In that spreadsheet, I'm using Power Query to transform the table from the newly insert spreadsheet into a separate output table.
The output table needs to be edited by users in addition to there being 2 new columns.
When users change a value in a cell on the output spreadsheet, if the data refreshes, their manually inputted work is deleted and reverts back to what the source spreadsheet had.
The Source spreadsheet CANNOT be modified by users for various reasons. One of them being is in the output spreadsheet is an automatic add column function based on various conditions.
The output spreadsheet is where staff is required to input new data into new columns in addition to changing values on existing rows where columns already exist in the source spreadsheet.
That data needs to stick on refresh. I'm stumped on a solution to this problem.
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

Forum statistics

Threads
1,223,382
Messages
6,171,771
Members
452,422
Latest member
rlynchbro

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