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 notes/comments, that no one else needs to see.
I was thinking of just linking the whole spreadsheet via the = [ ] etc function and then adding in the columns I need.
Is this the best way?
Thank you
7 Replies
- I'm still looking for a solution to this, if anyone has any simpler ideas to try. Thank you
- that no one else needs to see.
Authorize different persons with different views in co-work?
I guess you need a database backend and running a sql instead of excel file share.
possible situation like below:
https://club.excelhome.net/forum.php?mod=viewthread&tid=1520437&mobile= - 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/
