PivotTable Tools -> Options/Design tabs

B

Bishop

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?
 
A

Ashish Mathur

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Getting rid of PivotTable format 1
error - unreadable content in pivot table file - how do I find it 1
SUMIF FUNCTION works in all cells but those related to one account 4
Tabs in a cell 2
Update one worksheet tab to automatically update all other tabs? 1
Autofill in Various Tabs 1
VLookup multiple spreadsheets 2
Oversensitive touchpad on modern laptops 0

Top