Pivot Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When refreshing my Pivot Table, the sum function changes to count. Is there
any way to lock the function on sum?
 
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.)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Changing Default Function in Pivot Tables 1
Pivot Tables - standard Data Field function 1
Pivot Table 1
Pivot Table Shows Only Zeros 3
How can I get Pivot Tables to recognise time formatted data 1
Pivot table questions 1
default pivot tabel from count to sum 1
Pivot Table Calculated Field - Sum/count 1

Back
Top