Office challenge: Why is an Excel custom view generating an error?

This week, learn the solution to last week's Word challenge on styles and test your skills with a new Excel challenge.

Excel generates an error when a user tries to display a custom view. The error implies that Excel is unable to display the custom view correctly (see error below). What's generating the error and is there anything you can do to eliminate it?

Last week we asked…

How would you force a page break before every Heading 1 style instance in a Word document? You don't have to work with Word very long to learn the power of styles. If styles are properly applied, it's easy to accommodate a global change such as the one suggested in last week's challenge. To force a page break before every Heading 1 application, modify the Heading 1 style! Zwade.sandy was the first to respond with this sensible solution. To modify an existing style, do the following:

  1. Select text with the applied style.
  2. Click the Styles group's dialog launcher (the small diagonal corner in the bottom right corner. If you're using Word 2003, you'll find Styles on the Format menu.
  3. Word will open the Styles task pane, with the applied style selected.
  4. Click the style's dropdown arrow and choose Modify.
  5. Click the Format button and choose Paragraph from the resulting list.
  6. Click the Line And Page Breaks tab.
  7. Check the Page Break Before option in the Pagination section.
  8. Click OK twice to return to the document.

After making this modification, Word will force a page break before Heading 1 text. When modifying the style, remember that you can add the change to the template (probably Before clicking OK the second time, check the New Documents Based On This Template option (at the bottom) if you want to save the change to the template.