+ Reply to Thread
Results 1 to 3 of 3

Furmula oddity

  1. #1
    Registered User
    Join Date
    03-01-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2007
    Posts
    2

    Furmula oddity

    I am encountering a bit of an oddity.

    I am, and have been using several sum- and count-ifs formulas for a time, but when the new year rolled around, decided to improve some of the sheet.

    That all being said, the issue started after this. A specific set of my count and sum if functions started returning error values.

    I analysed them, they seemed fine, and then selected them and hit enter. Problem over in that cell, as suddenly the correct value is returned.
    But thatís just it, I know the formulas are correct and working, as, if I select and hit enter on them individually, they return the right value. However, every time I close the sheet and re-open, all the values are showing error again.

    I am perplexed. Did I inadvertently change a setting somewhere when I rebuilt the worksheet that is preventing the formulas from resolving correctly? As, like I said before, the formulas are fine, the data they are resolving, is fine. Just does not seem to calculate when I open the sheet. Refreshing does not help either.

  2. #2
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    2,265

    Re: Furmula oddity

    Maybe your formulas setting turn on to "Manual", change to "Automatic"

    First Step: Click on Formulas Tab on Excel

    First Two: Look at Calculation Options, an then choose "Automatic"

  3. #3
    Registered User
    Join Date
    03-01-2012
    Location
    Qatar
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Furmula oddity

    BINGO!

    Did not even know that exsisted. Thanks a ton Azumi!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] implement a furmula to range of cells using VBA
    By brdstyle in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-06-2013, 07:32 AM
  2. SUMIFS furmula
    By atlant15 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 12-17-2012, 03:38 AM
  3. Transfer value to other cell without the furmula
    By fatalcore in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-11-2011, 06:12 AM
  4. [SOLVED] Cell Block and Furmula Bar display
    By MAC in forum Excel General
    Replies: 3
    Last Post: 04-11-2006, 09:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1