"because your source data has automatic subtotals, MIcrosoft Excel cannot create a Pivot Table"

"because your source data has automatic subtotals, MIcrosoft Excel cannot create a Pivot Table"

I just got this error on a template that I have used for 6 other sets of data,

For some reason due ot haveing subtotals on the source data I am using for my Pivot, the Pivots will not refresh, and get the warning message:

"because your source data has automatic subtotals, MIcrosoft Excel cannot create a Pivot Table"

I do not get this message on the other 6 workbooks and have used Pivots on Data with Subtotals many times before.

Cheers, Kate