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

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Forum statistics

Threads
1,223,897
Messages
6,175,270
Members
452,628
Latest member
dd2

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