Hello, I am currently trying to run the code attached below.
test.zip (19.8 KB)
I keep getting an Error: ‘this data source is not supported.’
I was under the impression this should work, and you are working on integrating Power Pivot Model to refresh automatically for Power Pivot as well. Essentially, the Pivot Table RefreshDate function should be the same as clicking ‘Refresh All’ button on the Data tab, programmatically.