Hi - I'm currently using Excel 2016 Professional Plus. I have a workbook that contains a large data model. I have 20+ reports I need to create and this data model will be used as the repository that supplies all the information for those 20+ reports. However, every site/blog I read (granted most are from 2015 or 2016) says that you can't share a data model between workbooks unless you share the data model on sharepoint or use some kind of SQL Services. For whatever reason, I can't use Sharepoint or SQL and am trying to determine if I can share data models between workbooks. From what I can tell, I'd have to house all 20+ reports in the same workbook that contains the data model, which is just not possible with how large that file size would become. Is there any way I can share either a live or even a copy version of the data model to another workbook? I'm fluent in VBA and would have to think there's a way to at least take a snapshot form the workbook containing the data model and use that snapshot to update another workbook that could contain a copy of that data model. Any help is greatly appreciated!!
Thanks,
Jim
Thanks,
Jim