If you are using Windows XP and want to see how the menu commands relate to the ribbon commands, see You can use the tools in the Power Pivot window to discover when the data was last refreshed.To all, I have an Excel spreadsheet pivot table that is linked to an SSAS data source. In the last slide, there is a link to my Pivot Power Premium Add-in, which helps you solve most of these problems.So I have a pivot table with a data source internal in the workbook just a different sheet but it's not updating/refreshing whenever i click refresh nothing happens.To fix this, you can change a pivot table setting, so no old data is stored in the pivot cache.If you try to link to a value cell in a pivot table, a Get Pivot Data formula appears, instead of a simple link.
Or, fix your data, so it doesn’t contain blanks or text data in that field.
And for a list of all the pivot table tutorials and videos on my site, take a look at the Pivot Table Index page.
Here is a slide show that I made, summarizing the 5 Annoying Pivot Table Problems.
As much as I love Excel pivot tables, there are a few annoying problems that you’ll run into, while working with them.
I made a list of my top 5 annoyances, and you might have other problems to add to the list.