Hi @ExcelPro Sometimes ,
Based on the error message, I suggest you check the data format for the PivotTable. You can also provide the screenshots or sample data about the PivotTable here, so that I can get more accurate solutions to this problem. I’m glad to help and follow up your reply.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.