Good Afternoon,

I am working in a excel file that is primarily Power Query and Power Pivot data and pivot tables. The refresh time per Power Pivot table is extremely long. For example one table takes about 30 minutes to update. I’ve downloaded the OLAP Pivot Table Extensions add-in to improve performance. I was able to disable auto refresh and refresh all of the data in my power pivot data model. However when I went back to excel to enable auto refresh and refresh my pivot tables, I received the following error message:
“Problem enabling or disabling auto refresh. Exception has been thrown by the target of the invocation.”
I am using Microsoft Excel 365 64 bit. Does anyone know how to fix this error or have ideas on other settings that can be updated to improve refresh time?

Thanks!