I just discovered that when I update the pivot tables on other worksheets with new source data, it adds the new data to the existing pivot table and retains the old information too. I am wanting to completely update the pivot tables with only the new source data and have the existing pivot data removed. Not sure if this is also a caching issue.