We use cookies to provide you with a better experience. If you continue to use this site, we'll assume you're happy with this. Alternatively, click here to find out how to manage these cookies

hide cookie message
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


 

Excel Error Message


muffin1947

Likes # 0

I use Excel to keep a running account of my bank balance but when I click on the tick symbol at the top after doing a subtraction I get the following message.A small orange coloured box appears with this inside it !.When I hover the cursor over it this is the message I get. The formula in this cell refers to a range that has additional numbers adjacent to it.What does this message mean and how do I stop it.I use XPERROR

Like this post
difarn

Likes # 0

You could try

Tools > Options > Error Checking and turn off "Enable Background Error Checking".

Like this post
muffin1947

Likes # 0

Hi difarn Thanks for the reply but where to go to to find tools.Do I have to go into Excel or into my spread sheet.Have looked but cannot see tools anywhere.

Like this post
difarn

Likes # 0

I have just tried it on my 2007 excel

Go to the Microsoft button - top left Excel Options at the bottom Formulas on the left It is under error checking.

The instruction I gave was for a much earlier version of excel, sorry.

Like this post

Reply to this topic

This thread has been locked.



IDG UK Sites

Samsung Galaxy Alpha vs iPhone 5S comparison review: Metal smartphones fight

IDG UK Sites

Gateway to your kingdom: why everybody should check and update their broadband router

IDG UK Sites

Fonts review

IDG UK Sites

Best Mac? Complete Apple Mac buyers guide for 2014