I have this same question. I want to send a workbook to my collogues (each worksheet will be locked/protected) and I will keep the master (unprotected). When I make a change(s) how can all the other workbooks be automatically updated to show that change(s)? A pivot table will not work for me. I need all books to be updated as I make changes (prefer w/o sending new books every time a change is made)?
Asked
Active
Viewed 20 times
1 Answers
0
It sounds like what you need to do is use a cloud solution, something like Google Sheets or Microsoft's version of Office 365 in the cloud. You just create the document there and share a link to the document with your collaborators.
After creating a document and sharing it with your collaborators, you can see the edits they make and they can see yours. You can also set permissions on a per-sheet level, so if you want your collaborators to be able to see a certain sheet but not edit it, that is possible.
Sam Forbis
- 2,874