Tips.Net > ExcelTips Home > Formatting > Problems with Custom Views
Problems with Custom Views
Summary: If you get an error when you try to use one of your custom views, it could be due to the protection you have applied to the worksheets. This tip explains why this may cause a problem and what you can do about it. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)
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.
Tip #2621 applies to Microsoft Excel versions: 97 2000 2002 2003 2007
PivotTables Got You Perplexed? Learn the ins and outs of this powerful data-crunching tool. ExcelTips: PivotTables for the Faint of Heart makes it easy.
Confused by Time?
You can put times into a worksheet, but then what? Need to do calculations with times? How about working with elapsed time? Don't be confused; learn how easy it can be. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site