Excel Error Message

  muffin1947 08:23 04 Aug 12
Locked

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 04 Aug 12

You could try

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

  muffin1947 09:14 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 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.

Intel Coffee Lake 8th-gen Core processors release date rumours

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

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009