Skip to main content
NetApp Knowledge Base

How to create Temporary View within Cloud hosted Excel Spreadsheets.

not set
Last Updated:

Applies to

  • Excel Spreadsheets
  • Sharepoint hosted spreadsheets
  • Temporary views only apply spreadsheet data filtering.
    • Edits made to spreadsheet cells; still happen for all users when using Temporary views
    • Hiding columns or rows; still apply to all users when using temporary views


The intent is to describe how to use a Temporary view within a cloud hosted Excel Spreadsheets.

  • Apply column and row filters, without impacting the view of other users.
  • NetApp best practice is to avoid applying any filters, or hiding rows when viewing the Spreadsheet using the Default view

Cloud hosted Excel Spreadsheets

Any changes made to the Default view impacts all users
Auto prompting to enter Temporary View

Sometimes, when setting or clearing filters, the Excel Spreadsheet will automatically prompt the user:

Others are also making Changes,  Do you want to see sorting and filtering form others?

  • See just mine
    • When See just mine is selected, the user is put into Temporary view
  • See everyone's
    • When See everyone's is selected, user continues in Default view
Steps to Manually apply a Temporary view in a cloud hosted Excel spreadsheet

Tempororary views allow multiple users to be able to interact with one the spreadsheet, without applying widely varying filters or changes that can interrupt other user's work.  

  1. Click View from the tool bar at the top
  2. In the 'Sheet view' ribbon, click on New

Create New view

  • Dropdown will automatically update to Temporary View

Temp Sheet view

If it is a spreadsheet that you interact with on a regular basis, consider saving the view with a unique name, for future use.

Cloud hosted Excel Spreadsheets


Sign in to view the entire content of this KB article.

New to NetApp?

Learn more about our award-winning Support

NetApp provides no representations or warranties regarding the accuracy or reliability or serviceability of any information or recommendations provided in this publication or with respect to any results that may be obtained by the use of the information or observance of any recommendations provided herein. The information in this document is distributed AS IS and the use of this information or the implementation of any recommendations or techniques herein is a customer's responsibility and depends on the customer's ability to evaluate and integrate them into the customer's operational environment. This document and the information contained herein may be used solely in connection with the NetApp products discussed in this document.