Pivot Table COUNT Default Problem CURED!

14 11 2013


I had a delegate this week whose Pivot Tables would take any of his numerical data and by default count them rather than sum them. When he asked me why that happened I went through the normal explanation of data v numbers … which is true. However, in his case there seemed to be no reason behind this phenomenon: his data was clean as he was using my files and no one else had the same problem. He was using a good quality company laptop too.

We both checked on the internet last night and gained nothing from the many discussions on this problem: most of which related to data v numbers I have to say.

This morning I suggested that we look at his Windows Regional etc settings. His default language etc was US English and that seemed to be in order; but I said, let’s try this, change it to UK English and see what happens.

Ta daa! For some reason, this change did the trick and now this delegate’s Pivot Tables sum his data rather than counting it.

Another success story fromExcelMaster!

Duncan Williamson

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: