Excel Temporary Views not working

Question

Working with a team of 10+ are in and out of Excel files.

We have created a number of Temporary views, and despite working in the temporary filtering others are doing is being applied to the temporary view.

Someone maybe on the default view, or in their own view and filtering is getting applied to the separate temporary view.

Behaviour of the temporary view doesn't seem to be very consistent or provide functionality to work independently as we are trying.

Answer 1

Hi @ChristineZ9965 

Thank you for posting your question in the Microsoft Q&A forum.   

Regarding your issue, when you create or work in a Temporary View in Excel, it’s still tied to the Default View until you save and name it as a permanent Sheet View. This means: 

• If you apply filters or sorts in Default view it will affect Temporary View. 
• This is just how Excel’s current implementation of Sheet Views function. 

The best practice I can suggest your employees is before changing filters/sorts, pick your named view from the Sheet View switcher (eye icon). If prompted “Apply to just you or everyone?”, choose Just mine.  

I understand this can be frustrating and that in multi-user scenarios, perfect isolation of filtering isn’t always guaranteed. Microsoft continues to develop and improve these collaboration features, so hopefully future update of Excel will improve this feature better.  

Hopefully it will work for you and if you have any other questions or need further assistance, feel free to ask. 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.