How to schedule a pivot table in excel 2003?

[Guest]

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,

 

[steven1001]

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.

 

[Guest]

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,

 

[steven1001]

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..