Pivot Table

W

whtokbyu

When refreshing my Pivot Table, the sum function changes to count. Is there
any way to lock the function on sum?
 
D

Dave Peterson

You just clicked on the Refresh Data icon on the pivottable toolbar?
(or rightclicked on the pivottable and chose refresh?)

I've never seen excel do that when I do either of these (xl97, xl2k and xl2002).

What version of xl are you using? (Maybe someone can verify it for you.)
 
Top