When working on my spreadsheets I enter a simple formula into a cell, e.g.
=345+25, hit enter, and the Smart Tag appears showing the error that the cell
is not protected. I then must click and tell it to ignore the error and this
continues until I'm finished with all my entry.
I go to the next spreadsheet and enter an identical formula: =345+25, hit
enter and no error messages appear. Doesn't seem logical to me. (I hate
that when that happens.)
Thanks for any and all assistance.

If you want to turn off those annoying messages:

Goto ToolsOptionsError Checking tab.

Under Rules, uncheck everything that you don't want to be bothered by. I
have then ALL unchecked.

Biff

"DJ in KC" wrote in message
...
When working on my spreadsheets I enter a simple formula into a cell, e.g.
=345+25, hit enter, and the Smart Tag appears showing the error that the
cell
is not protected. I then must click and tell it to ignore the error and
this
continues until I'm finished with all my entry.
I go to the next spreadsheet and enter an identical formula: =345+25, hit
enter and no error messages appear. Doesn't seem logical to me. (I hate
that when that happens.)
Thanks for any and all assistance.

Tools Options Error Checking is not available in Excel 2007.
Inconsistent formula warning flags are very irritating since they never show
an error and take time to remove. Often entering a formula in one cell
results in flags in multiple cells which takes even more time to remove. Any
way to disable this? or remove all the flags at once?
BTW: Why is French the default language? Outlook Express will spell check
ONLY in FRENCH which is really irritating since they are such wimps.
Don
"Biff" wrote:

If you want to turn off those annoying messages:

Goto ToolsOptionsError Checking tab.

Under Rules, uncheck everything that you don't want to be bothered by. I
have then ALL unchecked.

Biff

"DJ in KC" wrote in message
...
When working on my spreadsheets I enter a simple formula into a cell, e.g.
=345+25, hit enter, and the Smart Tag appears showing the error that the
cell
is not protected. I then must click and tell it to ignore the error and
this
continues until I'm finished with all my entry.
I go to the next spreadsheet and enter an identical formula: =345+25, hit
enter and no error messages appear. Doesn't seem logical to me. (I hate
that when that happens.)
Thanks for any and all assistance.

In Excel 2007....

Office buttonExcel OptionsFormulasError Checking Rules.

Uncheck the ones you want then click OK.

I also have *all* of those unchcked!

--
Biff
Microsoft Excel MVP


"Don" wrote in message
...

Tools Options Error Checking is not available in Excel 2007.
Inconsistent formula warning flags are very irritating since they never
show
an error and take time to remove. Often entering a formula in one cell
results in flags in multiple cells which takes even more time to remove.
Any
way to disable this? or remove all the flags at once?
BTW: Why is French the default language? Outlook Express will spell check
ONLY in FRENCH which is really irritating since they are such wimps.
Don
"Biff" wrote:

If you want to turn off those annoying messages:

Goto ToolsOptionsError Checking tab.

Under Rules, uncheck everything that you don't want to be bothered by. I
have then ALL unchecked.

Biff

"DJ in KC" wrote in message
...
When working on my spreadsheets I enter a simple formula into a cell,
e.g.
=345+25, hit enter, and the Smart Tag appears showing the error that
the
cell
is not protected. I then must click and tell it to ignore the error
and
this
continues until I'm finished with all my entry.
I go to the next spreadsheet and enter an identical formula: =345+25,
hit
enter and no error messages appear. Doesn't seem logical to me. (I
hate
that when that happens.)
Thanks for any and all assistance.