Pivot table layout as tabular on right click

samdthompson

New Member
Joined
May 1, 2018
Messages
14
Hello, I have excel 2016 pro plus (not 365). I have an option (3rd from top) when I right click on a pivot table which says 'Tabular, no-subtotals layout'. Don't get me wrong, I love it but I am completely lost as to how I got it. I must have changed something at some point but as far as I know, its not a feature of 2016 pro plus. Anyone know how I might have got the option?.

It doesn't matter what the source of the pivot table, data model, SSAS, PBI, tables etc. Have hunted through every setting I can think of and even stumbled through the updates log. nothing rings a bell.

Cheers,

Sam
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Forum statistics

Threads
1,226,538
Messages
6,191,636
Members
453,668
Latest member
Stephen_Santos

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top