Good Evening Everyone:

I have two workbooks:
1) The first workbook contains multiple power queries from various sources
2) The second workbook uses external data connection for each of the tabs for 14 different pivot tables. I use this version to send out to others as to limit data file size.

On the second workbook, when I refresh all, it will pull all the data in from the first workbook, freeze, and then crash. When it reopens, all the data is there but some of the formatting on the pivot tables did not update. I have look in the external connections and verified paths (same workbook, 5 different tabs on the first workbook), ensure trusted data source, but can not figure out why it is crashing. Anyone else have this same type of issue or possible path for me to look to see why it crashes after pulling in the data?

Thank you!