Forum Discussion
Saving a mirror copy of a file so I can make my own amends
I am looking to save a copy of a live file (that I have shared access to) which is linked to the original file so all changes etc are updated, but which I can add a few extra columns for my own note...
No, it isn't. If anyone decides to sort the data in the original file, all your comments may be in the wrong location!
Ah, a very good point. Thank you. Is there a better / best way to do this then?
Thank you
- I've read about having a powerquery refer to itself to update it's external data and subsequently keep comments with the correct rows, but it is hard to setup. I found this article: https://exceleratorbi.com.au/self-referencing-tables-power-query/