EXCEL VBA关闭与外部EXCEL文件的所有打开的工作簿连接

I do have an issue with Excel and Data connections and hope to find a solution. Situation: I have an Excel Report with 2 external Data connection’s which feed into pivot tables. The Data Connections are linked to other Excel files containing the Raw Data for the Pivot Tables (Basically just one big Table) and have been setup using the Excel build in function via Data / Connections. Now every time I want to refresh the connections Excel is running out of Memory stopping with an error message.I do have an issue with Excel and Data connecti