Hi @Mayson Arnagiri ,
Did you mean when you try to download Excel Workbook from OneDrive to local, the PivotTable didn't not work?
What kind of data source did you use for the PivotTable?
Did the data source store in existed Workbook?
I suggest you try to create a new Workbook in local with the same data source and PivotTable and let me know the result.
Please be a bit more precise to explain your problem 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.