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