How can I Schedule PowerPivot to run SQL Query every morning.

[jersey]

Hi Everyone,

How can I Schedule PowerPivot to run SQL Query every morning. Im so stuck.


Thank you,
Cindy

 

[theBardd]

If you have Excel 2013 the PowerPivot object model has a Refresh method, so perhaps you could setup an OnTime function to do this.

 

[jersey]

thank you.

 

[powerpivotpro]

You now also have another option in the form of Power Update. Definitely worth a look:

Introducing Power Update! « PowerPivotPro