Some of these problems can be fixed with our add-in: fix and speed up Excel® files tools FREE ADD-IN. Save the file as file type ‘xls’ then back to ‘xlsx’ (or whatever the original file type was).Navigate to the folder ‘FILENAME.zip>xl’ file and delete the folder named ‘externalLinks’.
Also check chart titles and data label ranges. Check each series, if any ranges are in external files then cut the range from the external file and paste in to problem file. If you cannot break links in Excel® then follow these steps (backup your file first):
