I use excel to keep a running account of my bank acount which I print off on a regular basis but I keep getting the following pop up message and wondered what it meant.
I click on the = key and then the cell I am going to deduct a amount from then I click on the - key and then the cell with the amount I am going to deduct and finally I click on the tick sign which then gives the new total.The pop up message is a small orange coloured square with a diamond shape inside with a ! sign inside that does anyone know what this means
I think it is the information icon, as well. If you click on it you will see a number of options such as "Formula omits adjacent cells", "Update formula to include cells", "Help on this error" "ignore error" etc.
If you are happy that the spreadsheet is working as it should then just click "ignore error" and it will go away.
If anyone can tell me how to turn this feature off, I'd be very grateful as it annoys the hell out of me!
To turn it off in Excel 2007 go to the Office button and at the bottom click Excel Options. On the formulas tab there are all the error checking options and specific rules you can turn off. Click away to your hearts content!