About Filter Personalizations (For Consumers)

You can persist your selected filter values when you close and reopen a workbook by defining workbook states.

You make filter personalizations by changing the filter value selections for any filters and selection steps that are available to you. Filter personalizations don't apply to items in the filter bar.

You can configure a workbook to always open in a specific state, or you can choose which state to apply after you open the workbook.

The following workbook states are available:
  • Original State - This is the state in which the workbook author last saved the workbook. This is the default state when you open the workbook unless you set a different default state.
  • Last State - This is the state the workbook was in when you last made filter personalizations.
  • Custom State - This is a state you create to save a workbook with your preferred filter selections. You can create up to 15 custom states.

This tutorial shows you how to manage your workbook states. Tutorial icon Tutorial

For information about sharing a workbook URL that other users can use to view the workbook with specific filter selections persisted, see Share a Workbook URL with Persisted Filter Values.