Why am I getting this error for some worksheets that contain pivot tables?
Thanks for your query.
Please provide us your sample code or preferably a simple console demo application (runnable) to reproduce the issue on our end. You may zip the project and attach it here. Also, provide us your template file(s) (if any). This will help us to evaluate your issue soon to consequently figure it out soon.