Power Pivot Macros to Refresh All Data

[cocks17]

Hey

I'm looking to create a button for the user with a macro assigned to it to refresh all the data in the Pivots. However Im using power pivot for the data. If i record a macro and refresh power pivot it doesnt seem to record anything which happens in the power pivot window.

I'm looking to "Refresh All" in power pivot and then "Refresh All" in the main excel document after the power pivot data is refreshed. Any ideas how I migh achieve this?

Thanks
Paul