Saving a mirror copy of a file so I can make my own amends

Question

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

peiyezhu · Answer

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&amp;tid=1520437&amp;mobile=

jkpieterse · Answer

No, it isn't. If anyone decides to sort the data in the original file, all your comments may be in the wrong location!

kezjb · Answer

JKPieterse&nbsp;&nbsp;Ah, a very good point.&nbsp; Thank you. Is there a better / best way to do this then?&nbsp;Thank you&nbsp;

jkpieterse · Answer

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/

kezjb · Answer

Thank you for the reply but I can't read it as it isn't in English.&nbsp;peiyezhu&nbsp;

Forum Discussion

Saving a mirror copy of a file so I can make my own amends

7 Replies