How to schedule a pivot table in excel 2003?
 

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,

How to schedule a pivot table in excel 2003?
 

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: http://www.excelforum.com/member.php...o&userid=30757
View this thread: http://www.excelforum.com/showthread...hreadid=525974

How to schedule a pivot table in excel 2003?
 

Hi Steven,

Thanks for your suggestion.

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?

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

Thanks in advanced.

rgds,

How to schedule a pivot table in excel 2003?
 

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