I had a worksheet that I used to create a pivot table. I have updated the worksheet and gone to the pivot table and clicked on refresh but nothing changes. When I click on the date field in the pivot table and it opens a new worksheet with the data used to complete the pivot table the old information \is still showing on this worksheet. Help.