Software

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 Normal.dot). 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.

About

Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.

1 comments
Appletude
Appletude

The reason why the user is getting the specified error is becasue some of the columns or cells specified in the custom view may be protected and hence Excel prevents them from being viewed. If the user un-protects the excel sheet, user will no longer face that issue.

Editor's Picks