Speed Up Slow Running Excel File

MikeProductivityLeave a Comment

Given you are on this page, chances are you’ve seen this type of problem. Don’t put up with Excel® files running slowly and stopping you getting on with your important work. Chances are the slow file is due to a combination of three problems. All these problems are easy to fix. Go and look at your slowest spreadsheet file (probably … Read More

Excel Cannot Break Link – The Ultimate Guide

MikeProductivityLeave a Comment

EXCEL CANNOT BREAK LINK

If you cannot break links in Excel® then follow these steps (backup your file first): Unprotect each sheet in your problem file: HOME RIBBON – (CELLS) FORMAT – PROTECT SHEETS Break links: DATA RIBBON – (CONNECTIONS) EDIT LINKS – Select sheet then BREAK LINK Delete all named ranges to external files: FORMULA RIBBON – (DEFINED NAMES) NAME MANAGER Check all chart … Read More