The Formula You Typed Contains An Error

Is there any way to disable this pop-up from ever showing up in Excel 2007? In my experience, the error checking which calls this pop-up is buggy and tries to evaluate the contents of the cell when the user is trying to insert a reference to another cell rather than just when the user is trying to navigate to another cell. Furthermore, it evaluates the formula BEFORE the new reference is inserted rather than after, meaning that if the person were to type:

=-$

Then click on another cell, it would generate this pop-up even though the formula after inserting the reference would be legitimate.

Frankly I find this error message a humongous counter-productive waste of time, and flat-out infuriating. There's already quiet notes and error codes for other errors. Even when it's not giving false positives, the only thing this error pop-up has ever done for me is complicate and frustrate my attempts to fix my errors since I now have to wade through one to two pop-ups every time I want to test if my fix worked. Is there any way at all to stop this pop-up from showing up?

Like any application I know, Excel has rules to follow to avoid errors, have you read any, or all, of this?
Create a formula

As Groucho Marks said (paraphrased) "This is so simple that a child of three could understand it.. ........get me a child of three"...

On balance this "annoyance" is not so bad if you play the game by the rules.

Hi Strill and welcome to the forum

It doesn't look like it can be changed, at least in 2010 using Options -> Formula

What should happen when you type =-$ and click on another cell?