powerpivot - When i share a dynamic table from excel to another person they have trouble of compatibility

Question

I created an Excel Workbook, there are 2 dynamic tables in this workbook, the dynamic tables get feed with information from a data that is in power pivot, the same data from power pivot gets feed from data of Access, the problems is that when i share this Workbook with other people from work they have problems using the filter of the dynamic table because it just keeps loading and never ends, these people dont have access to the database from Access, I want to know how to solve this problem so that I canshare the Workbook to these people without having to share the database from Access.

question from:https://stackoverflow.com/questions/65941098/when-i-share-a-dynamic-table-from-excel-to-another-person-they-have-trouble-of-c

Answer 1

Those opening the file eother needs to have access to the external data, or you need to create a copy of the file. You can remove the external data connection before sharing the copy.