Stop equations updating dynamically when table is sorted/filtered

Originally Posted by RudiS

Welcome to the forum

If you switch Excel's calculation mode into manual it will stop your formulas from recalculating each time you sort.
The calc mode button should be on the Formulas ribbon...to the right. (I don't have a Mac, so I cannot confirm)

This seems to be working so far. Thanks for the fix!

For reference, it's the same option on the mac version. Formulas ribbon -> settings on the far right.