A little background first. I have this formula

=IF(OR(Area!A4="Chainage", Area!A5="Base Area:", Area!A5="Total Area:",
Area!A5=""), "", ((Area!B5+Area!B4)/2)*(Area!A5-Area!A4))

Fairly simple. I have dragged it down across two thousand rows so that all
the row refernences update automatically. Now I wish to make the references
(truely) absolute using the INDIRECT formula as the table it refers to will
have rows inserted into the middle of it as it expands and contracts.

I know this can be done using the Find&Replace tool as I have done it before
on a similar table.

What I have forgotten is how to temporarilly disable the "The formula you
have typed contains an error" message, since I cannot insert all the required
parenthesis at once.