This page is an advertiser-supported excerpt of the book, Learn Excel 2007-2010 from MrExcel - 512 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.
Hide Fields in PowerPivot
Problem: My data is coming from the company database. Those guys in I.T. have a bunch of strange field names instead of something that people can understand. There are a bunch a fields that no one will need in the pivot table.
Strategy: You can hide those fields in the PowerPivot Design tab so that the people using your pivot table won’t see the fields.
Select the worksheet in the green PowerPivot grid that contains the extra fields. Use the Design tab in the PowerPivot ribbon to find the Hide and Unhide icon. You can choose which columns should be available here in the power pivot window and which columns should be available in the pivot table.
Figure 958 You can prevent fields from appearing in the pivot table.