Forum Discussion
External data connections are removed
Hi,
A file of mine is seemingly corrupted and gives the following error on opening: "Removed Records: External connections from /xl/connection.xml part (Data connection)"
My setup is as f...
After further troubleshooting, I've narrowed the problem down to this:
- if I make standard pivot tables, it's fine
- once I add the datamodel function, it breaks
if I keep the pivot table (with data model) in the same file as the source data, then it works.
I really don't understand why it won't work across linked files (because it did in the past) - but I'll just have to work with this now.