DoktorPhill
New Member
- Joined
- Sep 23, 2020
- Messages
- 6
- Office Version
- 365
- 2010
- 2007
- Platform
- Windows
My spreadsheet references an external .xlsx database of a few thousand entries and the files are getting progressively larger.
I'm trying to cut down on the file size so I went digging inside the file using the .zip method. This file here externalLink2.xml contains the entire external database.
Is there a way to stop excel from embedding this data? Isn't the point of an external reference to cut down on multiple copies of the same data?
I'm trying to cut down on the file size so I went digging inside the file using the .zip method. This file here externalLink2.xml contains the entire external database.
Is there a way to stop excel from embedding this data? Isn't the point of an external reference to cut down on multiple copies of the same data?