I've got this nice report which has a Jet NL(Table) function, a pivot table with some slicers, and a Powerview sheet (Excel 2013).
When I refresh the report, all is updated automatically but not the Powerview sheet. I have to refresh that manually on the Powerview sheet itself.
Is there a way to have the Powerview sheet updated automatically when Jet refreshes the report?
Date
Votes
1 comment
-
Jet Reports Historic Posts Sounds like a feature request. We had to add code to manually refresh the pivot tables when a report refreshes a while back, so I'm sure that we would have to add code to manually refresh the powerview sheet as well. Can you maybe post this in the feature request forum?
Regards,
Hughes
Please sign in to leave a comment.