Auto Refresh Pivot Table
 

I have a spredsheet that gets updated with data every 3 min's. I have
added 3 pivot tables to the sheet and i need a way to get them to
update every 3 min. i really could use some help on this one.

Thanks
Chris


--
chris6562
------------------------------------------------------------------------
chris6562's Profile: http://www.excelforum.com/member.php...o&userid=15772
View this thread: http://www.excelforum.com/showthread...hreadid=272822

Auto Refresh Pivot Table
 

Look at Chip Pearson's site
http://www.cpearson.com/excel/ontime.htm

or, if this is done with DDE, then the Change event should fire. in any
event, loop through all your sheets and pivot tables on those sheets and
refresh them setting the backgroundquery parameter equal to false.

--
Regards,
Tom Ogilvy
"chris6562" wrote in message
...

I have a spredsheet that gets updated with data every 3 min's. I have
added 3 pivot tables to the sheet and i need a way to get them to
update every 3 min. i really could use some help on this one.

Thanks
Chris


--
chris6562
------------------------------------------------------------------------
chris6562's Profile:
http://www.excelforum.com/member.php...o&userid=15772
View this thread: http://www.excelforum.com/showthread...hreadid=272822