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,
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.
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,
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..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks