I would like to create a single excel spreadsheet that holds various links to other excel workbooks which each have data in powerpivot sitting behind them. i then hope to use vba code to go into each link, open the excel workbook and refresh the data in powerpivot.
Ive read some forums stating it is not possible to refresh power pivot using vba- is this true?
If it is possible, could someone share the method on how to refresh it please?
Thank you
one forum stated power pivot is not compatible with vba
New contributor
orla Lew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1