Forum Discussion

AndreasWeber1706's avatar
AndreasWeber1706
Copper Contributor
Dec 05, 2024

Use Central data model (established with PowerPivot) in other excel files?

Good morning. 

 

Hope you are all doing well. 

I have the following issue...

I established a datamodell in excel by using powerpivot. This all works fine so far in this excel. 

I would like to connect this data model also to other excel files for different analyses. 

 

Means, central datamodell in one excel file (which can be maintained centrally). Needed reports/analyses then established in separate excel files by taking the data from the central data modell.

 

I tried already, however not find a way to do that. 

Do you have an idea how to connect? 

Best regards 

Andreas

 

 

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor

    AFAIK the data model is bound to the workbook. So I guess it is not possible.

  • Thanks for the quick answer. It is a pity, but I have already an idea to organize differently! 😉

Resources