Do the green 'cell error' flags slow Excel calculations down at all?

[d0rian]

I need to optimize a file for performance: it's got thousands of formulas, VBA code, and pulls in hundreds of real-time stock market quotes via DDE. It's only 2MB in size, but often lags due to all of the calculations.

I know that I can turn error-checking off, but before I do that, I want to know whether leaving it on is a material drain on resources. Often, Excel 'thinks' that an entire column has formulas with errors (inconsistent formulas, numbers stored as text, etc), when they're actually built that way for a reason. But I notice that in identifying those cells as having errors, it populates the dark green 'error' flag very slowly/deliberately down the page, which made me wonder whether it's a resource-suck, which I want to avoid. I'd prefer leaving error-checking on (b/c it often finds legit errors on my part), but speed is more important so I just want to know whether it bloats the file before I make the decision.

F86K6wW.jpg

[CK76]

It has minimal impact on performance. Though, you can create a copy of the workbook and test by setting error checking off.

FYI - That column can be converted to number without issue as there's no leading zero that you need to keep. Provided, there are no formula that depends on it being stored as text.