Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a pivot table that is minimized by design. When the pivot table is restored it has four rows with the plus sign and you can click on the plus sign and each row will expand to show the details and this works fine. Is there a way to have all the rows auto expand when the pivot table is restored from its minimized state?
I think I answered my own question. If the properties dialog select the presentation tab and there is a check box that says "Always fully expanded". Check that and it will be restored fully expanded.