Disable Auto Refresh not visible

Dec 18, 2016 at 8:40 AM
Hi I have installed this successfully but I don't see any option that says Disable auto refresh.
Excel 2016: 32bit Windows 10
Dec 20, 2016 at 6:08 PM
What's the data source behind the PivotTable? Is it PowerPivot or an Excel data model? If you go to the DATA tab and click Connections, select ThisWorkbookDataModel and then click the link at the bottom which says "Click here to see where the selected connections are used" does it say your PivotTable is based upon the Excel data model? If so you should see the option. If not you won't. This feature is only for the Excel data model.