How do you propose to "know" that the data in the other workbook has been
changed?

Assuming you have a solution to that problem, your macro can open the source
workbook without it becoming visible, create the table, then close the
workbook.

On Mon, 26 Sep 2005 09:17:04 -0700, tommod
wrote:

Hi,
I'm trying to build a macro that runs automatically creating a pivot table
when I charge external data in a workbook, without opening the workbook. Is
this possible or I have to looking for another solution?
Thx
t