Hello everyone,
I have an excel spreeadsheet with powerpivot data, which needs to be copied and refreshed twice a week.
I managed to write a script that makes a copy of the spreadsheet, but I don't know how to refresh powerpivot data.
I googled the problem and found method QueryTable.Refresh...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.