Pivot Table - Show All

M

MikeBoston

Joined
May 20, 2008
Messages
6
Reaction score
0
I have a pivot table that is very large and I want to use a macro to reset once a user is done to show all pivot items. The table is 700+ rows long and I don't want to have to code each pivot item - besides I will not know the name of each item as the pivot table is updated.

I figured out that .showall coding doesn't work.

The only way I thought of doing this is having a backup pivot table on a hidden worksheet within the workbook. The macro will delete the pivot table the user manipulated and unhide the backup which will now have the show all. I then create a new backup and hide to repeat the process of getting a pivot table with show all.

Is there other ways to showall.
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unable to Group in Pivot Table 1
How I can set dynamic pivot table ONLY when I have enough data point 1
Expand and collapse 2
Pivot table multiple filters 2
Pivot Table Question 2
Using VBA to create charts 1
Playing back a Pivot Table macros 2
Excel 2010 Pivot Table 2

Top