Using Excel 2016, I have multiple pivot tables connected to a cube. I have the file configured so that it automatically refreshes upon opening.

The problem I'm having is that new months are collapsed by default, but I want them automatically expanded. This is a major problem since these pivot tables (and resulting pivot charts) are sent as automatic monthly reports.

An extensive search on the web has yielded no results. As I understand it the always fully expanded option isn't available in Excel 2016.

Is there a way to configure Excel so that it automatically expands all fields? A VBA script would be OK, but a non-macro solution would be preferable.