Thanks for your reply, however; I must not have been clear.
Once you pivot the data and you double click on the Summary data in the pivot, it creates a new tab with the records that are used to create the roll-up data that you doubleclicked on. It is this new tab that is being generated that I would like to have some control over the formatting.
Thanks!
God that sounds confusing, I hope someone can make it out.
