I have a series of Excel files. Each Excel file contains a few different sheets worth of raw data, and 3 or 4 pivot tables based on that raw data.

Each month I run a SAS program that updates the raw data in each Worksheet. Each time my update finished I thought I'd have to go through and manually update each Pivot table by right clicking and selecting "Refresh Pivot Table" but it seems to be updating the tables on it's own.

Does that seem right or am I nuts?