Problems with Custom Views

Custom views can be a great help in presenting data in a workbook. If you are using custom views, you may be surprised at some point by an error message that says “Some view settings could not be applied.”

Don’t despair if you see this message; it simply means that protection has been applied to one or more of the worksheets involved in the custom view. With protection enabled, any view settings that would violate the protection settings will not be applied and the message is displayed.

The solution is to either modify the view so it doesn’t use any of the protected worksheets, or remove the protection from the worksheets used in the view.