0

I have a excel sheet that is pulling from an external db via a power query and I was trying to find out if there is a way to edit cells in the spreadsheet and then prevent the power query from overwriting those values when you do a refresh. Is there a way to lock cells and prevent a refresh from changing those locked values? I want to be able to directly change cells in excel and then lock those cells from changing or refreshing.

Improve this question

1 Answer 1

Reset to default
0

See if this helps. Lets you save values as a comment column, but can be used for something similar

http://exceleratorbi.com.au/self-referencing-tables-power-query/

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.