Active Member
April 22, 2021
Hi,
First off, I apologise if this has been asked before but I've only started using power query 3 days ago, so I'm learning as I do power queries.
I'm completely confused as to how to have the manually entered data "saved" to the cell where it's entered, so when the table is refreshed/sorted the data isn't overwritten.
I have the following.
Main data table and main data connection only
stage 1 table and stage 1 connection only
I merge both based off 2 column IDs, sort columns in order required. This all works, but when I test(input) any manual data and update column ID 1 on the main data table and refresh on merged table it overwrites the data.
I've followed a few pages online but I keep missing something but I don't know what I am to get it working correctly.
Appreciate any help with this.
Damian
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
Power query result tables should not be edited, each time you refresh the query will read the source and reload data, overwriting what you edited.
If you need to add manual notes to some records, type that record id in a new table for manual editing, write your notes then merge this table to the query to display the notes attached to original data.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
PowerPoint
November 8, 2013
You can try visual basic coding.
But... if you run the codes again, what you type in the output area will also be replaced, unless you have a code that evaluates and compares the initial value to the updated value and writes the latest version of that cell.
PQ is the easiest way...