Sep 04 2018
03:12 PM
- last edited on
Feb 06 2023
03:45 AM
by
TechCommunityAP
Sep 04 2018
03:12 PM
- last edited on
Feb 06 2023
03:45 AM
by
TechCommunityAP
"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