+ Reply to Thread
Results 1 to 3 of 3

error box

  1. #1
    Scudo
    Guest

    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. #2
    Jan Karel Pieterse
    Guest

    Re: error box

    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. #3
    Scudo
    Guest

    Re: error box

    Thanks Jan
    that has worked for me.


    "Jan Karel Pieterse" <jkpieterse@netscape.net> wrote in message
    news:VA.000004d6.00818643@netscape.net...
    > 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 to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1