Pivot Table error - Cannot Summarise this field

Sineadd

New Member
Joined
Apr 24, 2019
Messages
25
Hi

I have just tried to update a pivot table which I used about 2 weeks ago except one of the fields from the Pivot table has been removed and when I go to add it back in on the field list and then change the Value field settings to sum it is giving the following error message - " We Can't summarise this field with Sum because it's not a supported calculation for Text Data types"

The data I am trying to sum is all number data and it worked perfectly up until today after adding data to the source table.

Can anyone shed some light as to why this is happening. The pivot table looks up data from another Excel workbook on the same network if that makes a difference. If I create the pivot table on the same workbook as the source data it works no problem but gives the above error when trying to update the report created on a different workbook

Thanks
Sinead
 

Some videos you may like

Excel Facts

Copy a format multiple times
Select a formatted range. Double-click the Format Painter (left side of Home tab). You can paste formatting multiple times. Esc to stop

Henkvz1

New Member
Joined
Jan 25, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
i have the same problem all of a sudden , any help please
 

Watch MrExcel Video

Forum statistics

Threads
1,123,276
Messages
5,600,686
Members
414,400
Latest member
Damocles2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top