An excellent article from the Microsoft Office Dev Center. Worth a serious read...

"...Follow these tips for optimizing many frequently occurring performance obstructions in Excel."

"...This article covered ways to optimize Excel functionality such as links, lookups, formulas, functions, and VBA code to avoid common obstructions and improve performance."

https://docs.microsoft.com/en-us/off...nces-and-links