View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jayneedshelp Jayneedshelp is offline
external usenet poster
 
Posts: 5
Default Updating a Piviot tabel when Excel data updates

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.