Hello,

I recorded a macro which creates a pivot table and when I create the layout
I make sure that it creates a sum result of the data. The initial creation
of the macro works great and I get the pivot table that I want. The problem
is that subsequence runs of the macro creates the same pivot table but
applies the Count function instead of the Sum. ?!?

I looked into the VB code behind but couldn't see anything that would result
in a different function being applied.

Has anyone else encountered this problem or have an idea as to how I might
be able to resolve this?

Thank you for your time.