![]() ![]() ![]() Navigate to the folder ‘FILENAME.zip>xl’ file and delete the folder named ‘externalLinks’.Rename it in file explorer: changing the extension from.Check Conditional Formats and Data Validation for similar phantom links.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. Check all chart series ranges: Right click chart – SELECT DATA – (SERIES) EDIT.Delete all named ranges to external files: FORMULA RIBBON – (DEFINED NAMES) NAME MANAGER. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |