Avani_Reddy - I'm attempting to use Excel Sheet View to solve an issue that we've had forever with the ability of multiple users being in the same document at the same time, applying various filters & hiding columns. Here are my questions I have, can you help answer them?
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.
- I want a master view to be able to see everything added to the file, do I use the Default View for this?
- We've found with individual views, we can filter in each view without messing with another user's view. However, if a user in View A hides a column, it also hides the column in View B as well as the Default . Is there a way to prevent this?
- The Link settings that allows for sharing a link but restricting access for the person it is shared with, how does this work? We would like to be able to share a link with a person for so many days, then that link would expire. Is this possible?
- I have one user that can only see the "editing view" and is not able to create new views. How do I change this?
Thanks!
Amanda