Apr 17 2020 05:29 AM
I have a file that we're wanting to utilize the Microsoft Excel Sheet View for and I have multiple questions on this.
Background : I have a file that we will need to have multiple users in the file at the same time making updates. In their updates, each user will need to be able to filter the data, hide columns, add columns, add formulas, add macros, make changes, etc. I want to set it up where I have a Master View, then the users have their own view.
Thanks!
Amanda
May 12 2020 09:10 AM
@Amanda_Fasano I am having similar issues. Did you ever find an answer to Question B?
My team is using Excel in Microsoft Teams and I have created sheet views multiple times. However, the option to select whether or not to view others' changes does not always pop-up and their column and filtering changes affect my view and vice versa. They are confident they are on different views than I am.
If there is a place to choose not to view others' changes that I can access (outside of it popping up) that may help.
If anyone else knows, please answer Amanda's original post to help us both out.
Thank you,
Amberley