[RESOLVED] Programatically Update Excel Files - A Question

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?

Do you have macros running when the spreadsheet opens? If so, they may be the onese doing the refresh for you.

I don't think I have any macros at all, no. Hmmm....

Nevermind - The "macro" in this case was a co-worker that went through and updated everything without my knowledge :rolleyes:

Not as reliable as a macro, but still works occasionally. :lol:

You can look at the "Last Modified by" property of the xls and see who did the "update"