Excel Error Message

  muffin1947 08:23 AM 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 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.

Advertisement

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

How to get free stuff for Android: Amazon Underground offers genuinely free Android apps and free…

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

MIT builds an awesome 3D printer that can use 10 materials at once

What to expect at the September Apple event: Apple announces 9 September event, sends out invites