Forum Discussion
Issue with pivot tables from data model
I have noticed lately an issue with excel the pivot tables don't update from the data model. data model refreshes data from external sources like SQL correctly but the changes don't reflect on the p...
Hi ,Martin
thanks for your reply
I have already checked for that ,there are no protections
the weird thing is that the same sheet was working good but lately this issue happened without me changing any thing
Do you understand correctly that's only PivotTable doesn't return update information, but if to check data model, e.g. in Power Pivot, queries update data model itself?
Or nothing is updated, includes data in data model?
yes exactly , the queries update the data model but some pivot tables are not updated. Despite refreshing the pivot table itself many times .the only way to solve the issue is to delete the pivot table and recreate it and in some cases after a few successful refreshes the issue appears again