Wednesday, April 5, 2017

Pivot: how to refresh pivot table on Excel file connected to offline cube

1. switch to Online
2. Refresh [data]
3. switch back to Offline (no need to re-run wizard)
4. check by clicking one of the dimension (list/values should appear without problem)

No comments:

Post a Comment