| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto refresh pivot table | Excel Discussion (Misc queries) | |||
| auto refresh pivot table | Excel Discussion (Misc queries) | |||
| Auto refresh pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table Refresh - Auto insert row | Excel Discussion (Misc queries) | |||
| auto refresh of pivot table | Excel Discussion (Misc queries) | |||
Linear Mode
