Jay,

The results from the SQL query are those retreived in an Excel sheet on
which you have a pivottable?

If so you could try the following by connecting your pivottable directly to
your datasource
1) Add a new pivottable
2) Select external source
3) Click get data
4) Select the query tab and select your query (or locate the query on your
machine by clicking browse
4) In the following step ammend the query as you like
5) Right click the pivot table and select "Table options"
6) Set the refresh every to any value you like (if the table should refresh
every 12 hours then set it to 720 minutes)

HTH

"Jayneedshelp" wrote:

I have a SQL query that runs every 12H. It puts the data into Excel and then
creates a new file and prints the pivot table. The problem is that the Pivit
table does not update when data in the querry updates.