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.
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
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
cheers will do it once I have everything right otherwise it don't show I have a error cheers
Bookmarks