HI ,
I have a sheet that imports data from a database , problem is that occasionaly the data has a currupt line in it wich then throws up an error on the sheet which in turn currupts the calculations on the sheet.
what i would like is a way of allerting the user that there is an error on the sheet ,
I have conditional formatting to do this at the moment but this needs the user to remember to look for errors ( may not be visable)
Is there a way for a warning to appear when the user opens and refreshes the sheet if there are anyt errors
I have a sheet that imports data from a database , problem is that occasionaly the data has a currupt line in it wich then throws up an error on the sheet which in turn currupts the calculations on the sheet.
what i would like is a way of allerting the user that there is an error on the sheet ,
I have conditional formatting to do this at the moment but this needs the user to remember to look for errors ( may not be visable)
Is there a way for a warning to appear when the user opens and refreshes the sheet if there are anyt errors