Excel Error Message

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

You could try

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

  muffin1947 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 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.

Should I upgrade to Windows 10? 8 reasons why you should upgrade to Windows 10... and 2 why you…

We are being sold the ability to spend money we don't have. And we love it

IKinema aims to banish droopy shoulders and wonky spines in animated CG characters

How to use Apple Music in the UK: Complete guide to Apple Music's features

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