• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Powerpivot data refresh with macro.

B

bluetaurean

Member
Is there a way to activate the powerpivot window and do a data refresh automatically with a macro.


the powerpivot has link to 20 external files which are pooled into excel and then relationship etc defined. I want the file to open every 60minutes and do the powerpivot data refresh, save and close the file.
 
Bluetaurean


Have a look here for lots of helpful Powerpivot stuff:

http://blog.gobansaor.com/2011/09/01/automating-powerpivot-refresh-operation-from-vba-the-code/
 
You must log in or register to reply here.
Back
Top