The latest Office 365 update provides a ‘pivotal’ new Excel feature. Now, you can finally personalise the default layout for your PivotTables. It’s been a popular request over at Excel UserVoice for some time and now it’s finally happened.

There are two ways you can adjust the layout settings for the PivotTable defaults, either via the newly added Edit Default Layout button under the File menu, or else through the PivotTable Options dialog box (pictured).

We’ll provide more details on this oft-asked for feature in June’s newsletter. If you haven’t already subscribed, feel free to add your name in the link at the bottom of any SumProduct web page.