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

[d0rian]

I've got a resource-intensive file with thousands of formulas, VBA code, and which pulls in real-time stock market data for hundreds of symbols via DDE. I need to optimize for speed/performance wherever I can.

In some of the columns, every cell has the dark green 'error' flag indicating an Inconsistent Formula (formulas are not mistakes; they're intentionally different than those in the columns to the immediate left/right.)

BUT rather than show up all at once, the green flags populate sequentially like a slow caterpillar crawling down the screen cell-by-cell, which made me wonder whether this is a hidden resource-hog at all...I know I can turn the Inconsistent-Formula error-check off, except that I actually want it active because it identifies real errors I do make on occasion. But speed is more important, so I'd turn it off if it were a resource-suck, I just don't know if it is.

 

[etaf]

file
options
formulas
Error Checking

 

[d0rian]

file
options
formulas
Error Checking

Thanks for reply, but...not sure you read my OP (or perhaps I was not clear enough): I am well aware that error checking can be turned off. It's just that I don't want to because sometimes it ID's inconsistent formulas that are errors on my part. BUT, I want to know if leaving it on, and having it flag the thousands of cells in a column that it thinks are errors (when they're actually not), is a resource-drain. As I wrote, the green flags often often populate very slowly/sequentially, which is what led me to believe that it's a more resource-intensive process, and if that's the case, I'll turn it off b/c I value speed/performance.

 

[etaf]

i dont know if they are a resource drain, anything that excel is having to check must use some sort of resource, but how significant i dont know
hence i thought if you turned them off you would know, by trying it out

I misread in the OP - that you did not know where the control was for the error checking and so how to turn off

so I'd turn it off if it were a resource-suck, I just don't know if it is.

i read as

so I'd turn it off if it were a resource-suck, I just don't know where it is.