Source Name Standard Next End If Next Next Next End Sub Overwriting the value on the pivot table row label also works. When I added in new data to source data, off of which an existing pivot table runs, I didn't see the new data when I refreshed the pivot table.
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.
That in fact is what happens when I run the refresh all manually.
However, when I run the VBA (which is actually in Access, but is correctly referenced etc) it updates the connections but NOT the pivot tables? Refresh All does as in matter of fact Refresh All connections and pivots.
However, in your scenario the pivots are probably based on the data you have to refresh first.
The pivot will refresh while the data is not loaded yet, hence the unexpected behavior.
I've check a number of Excel Pivot table settings but to no avail.
In your example, overwrite the value on the pivot table changing 'Antarctica' back to read "South America". Tip: change your data set to a table before you insert a pivot table. Removed the changes I made to the data source (ie, took out the income I added to a column) and when I refresh, the pivot table DOES NOT CHANGE.Refresh the pivot table or change the data source to update the pivot table with the applied changes. If you change any of the text or numbers in your data set, you need to refresh the pivot table. If I step through the code it works fine and the pivot table refreshes. Sarah I suspect that your query is only updating in background, so the Pivot Tables is being refreshed before the query has fininshed refreshing. By the way, the refresh All method should refresh the pivot table as well as the query, so the extra refresh command to refresh the pivot table isn't needed.