I have a workbook that brings data in from a SQL Server as the source data using a data connection (set up in the data connection wizard). I gave this table a name. Then I created several pivot tables from this data connection. The issue that I am having now is I would like to just refresh a single pivot table at a time and not refresh all pivot tables connected to the same pivot cache. I have read several threads that suggest changing the named range, I tried this and my pivot tables continue to use the same table name provided in the data connection. This is a problem because I can not seem to get rid of the pivot cache. Is there a way to write VBA to force Excel to just update/refresh the one pivot without refreshing all pivots attached to the pivot cache.