locked
OLAP Pivot Table Extension Error RRS feed

  • Question

  • Good Morning,

    I am working in a file that is primarily Power Query and Power Pivot data and pivot tables. I've downloaded the OLAP Pivot Table Extensions add-in to improve performance. I was able to disable auto refresh, 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.  Now I am unable to refresh any of my pivot tables and can no longer use this file. Does anyone know how to fix this error?

    Thanks!


    • Edited by A_Harris Thursday, September 6, 2018 2:42 PM
    Thursday, September 6, 2018 2:39 PM