Contact Forum Editor

Send an email to our Forum Editor:

PLEASE NOTE: Your name is used only to let the Forum Editor know who sent the message. Both your name and email address will not be used for any other purpose.

Tech Helproom

It's free to register, to post a question or to start / join a discussion

View Forum Rules | Contact Forum Editor

 

Excel

1 next »

ponytail

Likes # 0

Posted April 28, 2012 at 8:42AM

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

Like this post
Taff™

Likes # 0

Posted April 28, 2012 at 9:20AM

If you click on it does it show a message. Something like "formatting is not the same as adjacent cells"? It's an information icon I think but feed us some more info.

Like this post
GroupFC

Likes # 0

Posted April 28, 2012 at 9:48AM

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!

Like this post
VoG II

Likes # 0

Posted April 28, 2012 at 9:58AM

In Excel 2010, File tab, Options, Formulas, Error checking rules. Untick those you don't want.

Like this post
Taff™

Likes # 0

Posted April 28, 2012 at 10:03AM

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!

Like this post
ponytail

Likes # 0

Posted April 28, 2012 at 10:30AM

Hi Guy's am on excel now but cannot see the office button or the file button.

Like this post
Taff™

Likes # 0

Posted April 28, 2012 at 10:45AM

Hi VoG™ - Long time ....

Which version of Excel are you using ponytail? The Office Button is the icon very top left in 2007 & 2010

Like this post
ponytail

Likes # 0

Posted April 28, 2012 at 11:02AM

I have office 2007

Like this post
ponytail

Likes # 0

Posted April 28, 2012 at 11:07AM

Thanks taff have found it but still not sure which one to untick it must be one of the ones which comes under eror checking rules but which one dont want to untick the wrong one.

Like this post
VoG II

Likes # 0

Posted April 28, 2012 at 11:08AM

Hi Taff™

It is the multi-coloured button, top left of the screen.

Like this post
Taff™

Likes # 0

Posted April 28, 2012 at 11:11AM

What does the information icon on the spreadsheet actually say?

Like this post

1 next »

Reply to this topic

This thread has been locked.



Check out PC Advisor's other tech forums

Send to a friend

Email this article to a friend or colleague:

PLEASE NOTE: Your name is used only to let the recipient know who sent the story. Both your name and the recipient's name and address will not be used for any other purpose.