Forum Discussion
Issues refreshing Pivot Table
Hi! I've a Pivot Table that when I try to change its Data Source to a new one, Excel just closes with no message on screen, someone know how can i achieve this? Or how can I copy the table structure without the Data Source to connect later the new one
When Excel opens again the repaired file says something like "The table was discarded due to integrity problems"
- Solved!
It is an error introduced on the last version, so... nothing to do, I'll downgrade the version and that's all
- What kind of pivot table is it? Tied to a regular Excel range or table, or to the data model?
JKPieterse It's a normal Pivot Table connected to an external datasource, in this case an OLAP CUBE in SSAS Services
- Does it work if you try to connect a new pivot table in a new workbook to that same source?
- Solved!
It is an error introduced on the last version, so... nothing to do, I'll downgrade the version and that's all
