Excel Error Message

  muffin1947 08:23 AM 04 Aug 12

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

  difarn 08:30 AM 04 Aug 12

You could try

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

  muffin1947 09:14 AM 04 Aug 12

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.

  difarn 12:12 PM 04 Aug 12

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.


This thread is now locked and can not be replied to.

Surface Book review: Hands-on with Microsoft's impressive first laptop (better yet, it's a tablet t)…

1995-2015: How technology has changed the world in 20 years

The Walking Dead VFX: a look back from Seasons 1-6

New Apple TV 2015 release date and UK price: buy from Apple in late October, in store in November