Error marker re appears after sort

gazza uk

New member
Joined
May 29, 2014
Messages
41
Reaction score
0
Points
0
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
 

vinod

New member
Joined
Jun 2, 2011
Messages
15
Reaction score
0
Points
0
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.
 

gazza uk

New member
Joined
May 29, 2014
Messages
41
Reaction score
0
Points
0
cheers will do it once I have everything right otherwise it don't show I have a error cheers
 

razisartaj

New member
Joined
May 25, 2014
Messages
7
Reaction score
0
Points
0
Error marker

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
 
Top