Error message in Excel

  ponytail 09:05 AM 15 Sep 12
Locked

This is about a post with ref to a post I posted on April 28th titled Excel. While I am working on a spread sheet which is a running account of my bank statementI keep getting the following message. I click on say cell E367 then = then cell E366 then - then cell B367 then the equals tick. The message that follows is a orange coloured square with a diamond shape inside containing a ! and the message I get when I hover the cursor over it is,

  ponytail 09:11 AM 15 Sep 12

This is about a post with ref to a post I posted on April 28th titled Excel. While I am working on a spread sheet which is a running account of my bank statementI keep getting the following message. I click on say cell E367 then = then cell E366 then - then cell B367 then the equals tick. The message that follows is a orange coloured square with a diamond shape inside containing a ! and the message I get when I hover the cursor over it is The formula in this cell refers to a range that has additional numbers adjacent to it.

Not sure what just happened as I was in the middle of typing this post and it looked as though it had been sent without me sending it if it did it will only be half the post if so please ignore the first one.Hope someone can help sorry it is so long.

  Woolwell 11:52 AM 15 Sep 12

It is probably telling you that the adjacent cells have numbers in too which you haven't included in a sum.

You can turn off error checking but need to know which version of Excel.

  ponytail 14:44 PM 15 Sep 12

Hi Woolwell,I am using Excel 2007

  Woolwell 15:29 PM 15 Sep 12

To turn off error checking - then go to MS orb top left - then Excel Options and then on formulas you can uncheck what you do not require. I am not sure in this case but you could try Formulas which omit cells in a region.

  ponytail 19:27 PM 15 Sep 12

Hi Again Woolwell, Have done what you suggested and will try to do some work on the spread sheet tomorrow.Will put the results on here.

  ponytail 09:18 AM 16 Sep 12

Hi Woolwell Have done some transactions this morning and so far that message has not appeared so hopefully itis sorted.Thanks for the advice

Advertisement

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

New Moto G 2015 confirmed: Motorola Moto G UK release date, price and specification details - New…

Why Vodafone’s frequency choice should interest you: The benefits of 800MHz

Digital visionaries lined up for dConstruct

Apple Pay UK launch guide and participating UK banks: HSBC, First Direct finally support Apple Pay