Tuesday, October 18, 2011

Eliminate Error Values in Your Pivottable (2000/2002/2003/2007)


Resolve Errors.
If your PivotTable’s source data contains errors, you’ll notice those errors pop up in your PivotTable too. Here’s how you can replace error values with blank cells in your PivotTable:
  1. Click anywhere within your PivotTable to view the PivotTable toolbar (or choose View | Toolbars | PivotTable from the menu bar).
  2. Click the PivotTable button on the PivotTable toolbar and choose Table Options from the resulting menu. Excel displays the PivotTable Options dialog box. (In 2007, click on the PivotTable button on the PivotTable Tools ribbon, then choose Options.)
  3. Select the For Error Values, Show check box, and leave the corresponding text box blank.
  4. Click OK to return to your PivotTabl
   There’s a lot more regarding MS Office, for more information stay connected…

0 Responses to “Eliminate Error Values in Your Pivottable (2000/2002/2003/2007)”

Post a Comment

All Rights Reserved Tech-next| | Blogger Template by Bloggermint
© TECH NEXT INDIA 2011. Powered by Blogger.