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

Refresh closed workbook

Mr.Karr

Member
Hello

Is it possible to refresh a cube/powerpivot from the closed workbook? Any advise or recommendations on this?

Imagine, I have a list of cube names and powerpivot details with the other workbook. Can I have it hardcoded or using any other alternate methods to refresh. Please advise.

Many thanks in advance,
Karthik
 
In a workaround you could something like below.

Open said wb
Refresh connection in this workbook
Close said wb
 
Back
Top