Last month, I had an Excel spreadsheet with 20 pivot tables within 10 separate worksheets. If I hit the refresh button on any one pivot table, all the tables refreshed. Today, I must hit the refresh button on each separate pivot table to do a complete refresh. I do not know what I did to make this change. Can anyone tell me what I possible did to modify the refresh capability?