Programmatically manage pivot table.
I am using Excel 97.
I have a spreadsheet with the names of clients in column A and their
amounts in column B.
I recorded a pivot table where the client names are long the side and
the sum of column b is in the pivot table.
For whatever reason, the pivot table will sometimes count and not sum
the values in column B.
I wanted to know if it is possible to tell the pivot table by code to
sum the values. Or is there a better way to make sure that the macro
sums the values in column b and not count the values ?
|