Allow temporarily broken formulas
I have a long list of formulas, and want to nest every formula within another if statement. Using find and replace to replace the beginning and end of every formula (the parts that don't differ between each one), this should be very easy. However, excel won't let me change a single one because, when I try to replace the text, "the formula is missing an opening or closing parenthesis."
I can appreciate having error checking for formulas, but there should be SOME way to either bypass this error checking or turn it off! This is frustrating me to no end.
Voted. ...I've not searched for it, but do seem to recall that there is an existing thread running for the same request (maybe with a higher vote count).
Maybe it could be made a part of setting calculation to manual.
You need to do this, you set Calc to manual, do your thing/s, set it back to auto and see how you did (do the errors roll in or is everyting jake?)
If it could be tied into the manual Calc feature, that might be an easy way to achieve it.
It has been suggested for a long time now that Excel introduces Regular Expressions into search and replace. This would solve the issue at a stroke as well as allowing for more flexibility throughout. It's all there in VBA already, how hard would it be to implement in the Search and Replace box?
That IS obnoxious, and the workaround that works now did not for many years. YOu had to replace "=" with something like "k=" and do the F&R-ing, then remove the "k"...
Should be an Option to click in F&R, like all the other Options available. Then it holds the cells being changed in abeyance, lets you do several operations, leaving the function box if need be and returning. Only when one clicks Finished would it check for broken formulas.
Preach it brother!
Paul Urbanski commented
This is the kind of thing that can make me want to use Google Sheets instead--they don't have this problem.