Hello internet! I want to prevent users from manually changing values of items in a pivot table. What are my options in doing this? I already tried protecting the sheet but this remove the capability for them to refresh the pivot. Any idea is greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
How to prevent pivot table modifications
Similar threads
- Solved
