Home |
Search |
Today's Posts |
#1
|
|||
|
|||
error box
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
Thanks Jan
that has worked for me. "Jan Karel Pieterse" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|