Updating a Custom View

You cannot edit existing Custom Views that you've created, but you can replace a view using either of these approaches:

• Delete and recreate the view:
  1. Choose View | Custom Views and then click once on the view that you wish to update.
  2. Click the Delete button and then click Yes to confirm that you wish to delete the view.
  3. Create a new version of the view.
• Replace an existing view:
  1. Choose View | Custom Views | Add, enter the exact name of an existing Custom View in the Name field of the Add View dialog box, and then click OK.
  2. Click Yes on the prompt that informs you that the view already exists and asks if you would like to delete it and continue.

Removing all Custom Views from a workbook

Sometimes, you may encounter a workbook that has numerous Custom Views. For instance, the Review | Share Workbook command creates a Custom View for each user that accesses the workbook. Over time, this can result in an overwhelming number of Custom Views...