error box

[Scudo]

On my spreadsheet I keep getting a little error box after I insert data
which I assume is due to formatting, I just click ignore error and it goes
away, is there a way to stop this message appearing in the first place, like
somewhere I can switch it off.


thanks

[Jan Karel Pieterse]

Hi Scudo,

> On my spreadsheet I keep getting a little error box after I insert data
> which I assume is due to formatting, I just click ignore error and it goes
> away, is there a way to stop this message appearing in the first place, like
> somewhere I can switch it off.

When it shows up, select "Error checking options" from its dropdown menu. Then
uncheck all you wish Excel to ignore.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com

[Scudo]

Thanks Jan
that has worked for me.


"Jan Karel Pieterse" <[email protected]> wrote in message
news:[email protected]...
> Hi Scudo,
>
> > On my spreadsheet I keep getting a little error box after I insert data
> > which I assume is due to formatting, I just click ignore error and it
goes
> > away, is there a way to stop this message appearing in the first place,
like
> > somewhere I can switch it off.
>
> When it shows up, select "Error checking options" from its dropdown menu.
Then
> uncheck all you wish Excel to ignore.
>
> Regards,
>
> Jan Karel Pieterse
> Excel MVP
> http://www.jkp-ads.com
>