Pivot Table - Disable the Show/Hide Detail upon refresh
 

I have multiple worksheets with Pivot Tables that refresh from one main
worksheet within the workbook. I know how to Show/Hide detail but I lose
that everytime I refresh it. Isn't there a way to maintain my options when I
save the workbook? I want to hide detail and I have to do that every time I
run a fresh at a later date because it reverts to Show detail everytime.

Your help or tips are most appreciated.