Results 1 to 4 of 4

Thread: Error marker re appears after sort

  1. #1

    Error marker re appears after sort



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I Have formulas in a sheet with which has to be sorted as its updated but when I do the little green corner appears in the cell again and I have to click ignore error again to remove it how do I stop this coming back after a sort has been done on the sheet I have over 1000 cells with formulas in then

  2. #2
    Hi Gazza,

    It is simple.. just follow the below instructions.

    1. Go to MS office button(right above corner)>> Excel options>> Formula category ----- ALT + T + O
    2. Formula Category >> Clear the Enable background error checking check box.
    Vinod

  3. #3
    cheers will do it once I have everything right otherwise it don't show I have a error cheers

  4. #4

    Error marker

    Quote Originally Posted by gazza uk View Post
    cheers will do it once I have everything right otherwise it don't show I have a error cheers
    Hey Just I would like to add that above mentioned thing is not for excel 2003

Posting Permissions

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