1. Do you mean create a view in sql db and then schedule it using 'sql
server agent - jobs' to be refreshed every n hours?
.... thats the sort of thing I had in mind although I would
'subcontract' this task to a DBA ;-)

2. How to 'tell' the PT to refresh? Do i need to open the PT file all
time?
.... right-mouse-click in pivot table, go to table options, bottom
right hand corner "refresh every N minutes" (this is in Excel 2003 -
dont know which other versions support this)

regards..


--
steven1001
------------------------------------------------------------------------
steven1001's Profile: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=525974