software

Hi,

Currently i have a pivot table which import data from MS SQL database via
ODBC. Would like to know is there a way to schedule it to run with specify
time?

Thanks in advanced.

rgds,


can u create a view in the sql database that is created/refrshed every n
hours and then point the pivot table to that view and tell it to
auto-refresh? The PT will then change as frequently as the view in the
sql db.--
steven1001
------------------------------------------------------------------------
steven1001's Profile: www.excelforum.com/member.php...oamp;userid=30757
View this thread: www.excelforum.com/showthread...hreadid=525974Hi Steven,

Thanks for your suggestion.

1. Do you mean create a view in sql db and then schedule it using 'sql
server agent -gt; jobs' to be refreshed every n hours?

2. How to 'tell' the PT to refresh? Do i need to open the PT file all time?

Thanks in advanced.

rgds,
1. Do you mean create a view in sql db and then schedule it using 'sql
server agent -gt; 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 quot;refresh every N minutesquot; (this is in Excel 2003 -
dont know which other versions support this)

regards..--
steven1001
------------------------------------------------------------------------
steven1001's Profile: www.excelforum.com/member.php...oamp;userid=30757
View this thread: www.excelforum.com/showthread...hreadid=525974