+ Reply to Thread
Results 1 to 3 of 3

formulas all quit working

  1. #1
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    2003, and 2007
    Posts
    150

    formulas all quit working

    for some reasons all of my formulas quit working on my computer in excel. I am thinking that I must have something set up wrong some place, but have not done anything that should have changed my formulas

    Its not that they are gone but just are not auto calculating.
    I tried just a basic sample invoice and the figures do not calculate without manual calclation
    Last edited by 2funny4words; 03-11-2009 at 06:10 PM.

  2. #2
    Forum Contributor
    Join Date
    01-05-2009
    Location
    South Dakota, USA
    MS-Off Ver
    2003, and 2007
    Posts
    150

    Re: formulas all quit working

    Tools - Options.
    Go to the Calculation tab and set Calculation to Automatic instead of Manual.

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: formulas all quit working

    You must have run some code that failed to return calculation back to automatic.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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