Create and share saved views
Saved views were formerly known as bookmarks.
Saved views allow you to “bookmark” changes you’ve made on top of a published workbook and return to them at any time. Saved views support saving changes of varying complexity, from adding just a filter or control, to adding new charts and data. You can create saved views just for yourself (personal views), or share them with other members of your organization (shared views).
This document explains:
- Considerations when using saved views: Evaluate whether saved views are suitable for your workflow
- Bookmarking your changes in a saved view: Create a new personal or shared view
- Collaborating with other users by sharing views: Share an existing saved view with others users
- Accessing your previous views: View your most recent or all saved views
- Managing your saved views: Edit an existing saved view, or rename/delete a saved view
System and user requirements
- All users with access to a workbook are able to save personal views.
- You need Create, edit, and publish workbooks account type permissions to save a shared view. See Account type and license overview.
- Guest users cannot create shared views.
Considerations when using saved views
Saved views depend on the underlying workbook. Any changes, such as adding/removing filters, duplicating pages, or deleting elements in the underlying published workbook can affect or break saved views. You will need to manually delete or update your saved views to resolve conflicts between the published and saved view versions.
For example:
- Deleting a filter from the published workbook removes the filter from all saved views.
- Deleting a data table from the published workbook results in all child elements (such as charts, pivot tables) being removed from the related saved views.
The more changes are made on the bookmark, the more likely it is that small changes in the underlying workbook will affect or break your analysis in the bookmark.
As a result, saved views are not recommended as a version control tool. Saved views are best for preserving a particular workbook configuration for later reference and editing, such as saving a set of filters that a specific team may want to return to frequently.
If you want to support a version control workflow, consider using version tags instead. Version tags are best for preserving a static snapshot of a workbook at a particular state in time, but cannot be edited directly like saved views. See Create and manage version tags.
Create or share a new saved view
When creating a saved view, you can create them as either personal or shared views. Personal views are visible to only you, and are useful to save changes only you need to access. Saved views can be shared with multiple members of your organization, and can be used for collaboration.
To create a saved view:
- Make changes in a custom view.
- From the document menu, select Custom view, then Save this custom view.
- Enter your desired view name.
- Save it as either a personal or shared view:
There is a limit of 10 shared views for each version of a workbook. There is no limit on personal views.
- Personal view: Select Save.
- Shared view: Select the checkbox next to Shared view, then select Save.
- (Optional) To set this view as your default landing page when viewing the workbook, select Set as default view.
Share an existing saved view
Sending a link of a saved view to another user will make the changes in your saved view available to the user as a new custom view. To collaborate on the same shared view, you should make the personal view a shared view.
To share an existing personal view as a shared view:
- From the document menu, select Custom views, then All views.
- From the Saved views tab, select click
More next to the personal view you want to share, then select Set as shared view. This makes the shared view visible to all users who have Can view or Can edit access to the workbook.
Accessing previously saved views
To access previously saved views:
- From the document menu, select Custom views.
- To view your most recent saved views, select the view under Recent saved views.
- To view all previous custom views, select All views.
- Select the Saved views tab to see previous custom views.
Manage saved views
Editing saved views
To edit and save changes to an existing saved view:
- Open your saved view. From the document menu, select Custom views, then All Views. From the Saved views tab, select your saved view.
- On your saved view, make changes to the workbook.
- From the document menu, select Custom views > Save to [Name of your saved view].
Renaming or deleting saved views
To rename or delete existing saved views:
- From the document menu, select Custom views, then All Views.
- From the Saved views tab, select More ⋮ next to your saved view.
- Select Edit name or Delete:
- Edit name: Enter your desired name.
- Delete: Select Delete.
Updated 1 day ago