I have an excel table which is used by tens of other people to imput data monthly. It seems that it is impossible to keep it in shape (confitional formating, links,...) just by instructing the users not to copy-paste stuff from their personal work spaces and thus accidentally also overide the definitions. So, I need excel protection. I have encountered two problems:
1) Protection doesn't seem to protect the hyperlinks. The links even in the protected cells seem to change after the updates of some of the users. Any ways to avoid this?
2) How can I protect a sheet so that the grouping show/hide functions still work on that protected sheet?
Bookmarks