Excel 2007 : Restore PiviotTable Tools Ribbons

**jader201** · 04-22-2009, 12:14 PM

When creating a PivotTable, two ribbons pop up to give you additional options specific to PivotTables: Options and Design. Both of these appear under a red heading in the title bar, "PivotTable Tools". Additionally, a pane appears on the left, titled "PivotTable Field List".

My question is this. When selecting cells outside of the primary pivot table, or when selecting columns/rows, these two ribbons and the pane all disappear. I've searched all over the options and other ribbons, and searched online for how to restore these, but can't. Once you do this, you're pretty much locked in to the pivot table as-is, and are no longer able to change anything.

I'm hoping this is something very easy that I've overlooked, and not a limitation, or "feature", of Excel 2007.

Thanks in advance for any help.

**martindwilson** · 04-22-2009, 10:13 PM

doesnt right clicking in the pivot table get them back or give access to them?. cant test it myself just a guess

**Paul** · 04-22-2009, 10:45 PM

Have you tried clicking a cell in the Pivot Table again? This is normal functionality for all versions of Excel.

While you're in the Pivot Table, the PT options/fields/etc. are available, but as soon as you click outside the PT they disappear. Once you click back into the PT, everything re-appears. Or should. I've never seen that not the case.