Forum Discussion
AndreasWeber1706
Dec 05, 2024Copper Contributor
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_LewinSilver Contributor
AFAIK the data model is bound to the workbook. So I guess it is not possible.
- AndreasWeber1706Copper Contributor
Thanks for the quick answer. It is a pity, but I have already an idea to organize differently! 😉