PivotTable Tools - Options/Design tabs
 

How do I add these two tabs to a spreadsheet? I have 2 spreadsheets open.
One of them has the PivotTable Tools section which includes the Options tab
and the Design tab. The other spreadsheet doesn't have these. How do I get
them on there?

PivotTable Tools - Options/Design tabs
 

Hi,

In the other workbook, you have to be clicked anywhere inside the pivot
table. Then you will be able to see Options Design

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Bishop" wrote in message
...
How do I add these two tabs to a spreadsheet? I have 2 spreadsheets open.
One of them has the PivotTable Tools section which includes the Options
tab
and the Design tab. The other spreadsheet doesn't have these. How do I
get
them on there?