Log In
Register
Home
November 15, 2012
Offline
Hello,
I have a data model I update every month with new sales data. I store the data in Access and link the Access database to my data model in Power Pivot. I've been doing this for a couple of years with no issues. This month I updated Access with no issues and the Power Pivot data model updated with no issues. I can see the new data in Power Pivot. For some reason when I refresh the pivot tables that new data that I can see is in the data model, will not be updated in the pivot tables and charts. I've never seen this happen before and I have no idea what to do. I've refreshed every pivot table, refreshed Power Pivot, in connection properties I've deleted and added the connection file back again, I deleted the data from Access and imported again successfully and refreshed everything again, nothing is working. Any help with this issue would be greatly appreciated. Thank you!
-Scott
July 16, 2010
Offline
Hi Scott,
I've not heard of that either. Maybe something has become corrupt between the old PivotTables/charts. Presumably you can build new PivotTables and charts and it picks up the new data?
Mynda
1 Guest(s)
