![]() ![]() 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.Break links: DATA RIBBON – (CONNECTIONS) EDIT LINKS – Select sheet then BREAK LINK.Unprotect each sheet in your problem file: HOME RIBBON – (CELLS) FORMAT – PROTECT SHEETS.If you cannot break links in Excel® then follow these steps (backup your file first):
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |