Connecting to a Power Pivot model from another Excel workbook

Hello Anonymous 

the only possibility to access the data model itself it's only possible when you have opened  the other Excel with the datamodel (if even - i know it's possible with Power BI). But this doesn't suit the most business scenario.

The way I've solved such issues to create in your excel as many pivots as you need in other scenarios and then access the data of the pivot table. However you have to update the excel-file manully, every time your data model changes.

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy