+ Reply to Thread
Results 1 to 4 of 4

Spreadsheet not calculating

  1. #1
    Registered User
    Join Date
    02-01-2006
    Posts
    60

    Spreadsheet not calculating

    Hi,

    I am having problems with a spreadsheet where the formulas are not re-calculating, even though auto calc is on.

    If i hit F2 on the formula and then enter it works though.

    Any ideas?

    Garry

  2. #2
    Niek Otten
    Guest

    Re: Spreadsheet not calculating

    What's your formula?

    --
    Kind regards,

    Niek Otten

    "Gazzr" <[email protected]> wrote in
    message news:[email protected]...
    >
    > Hi,
    >
    > I am having problems with a spreadsheet where the formulas are not
    > re-calculating, even though auto calc is on.
    >
    > If i hit F2 on the formula and then enter it works though.
    >
    > Any ideas?
    >
    > Garry
    >
    >
    > --
    > Gazzr
    > ------------------------------------------------------------------------
    > Gazzr's Profile:
    > http://www.excelforum.com/member.php...o&userid=31075
    > View this thread: http://www.excelforum.com/showthread...hreadid=520836
    >




  3. #3

    Re: Spreadsheet not calculating

    Increase the number of iterations (same screen where you turn on
    auto-calculate). Increase it to 100 and see if that helps. ed


  4. #4

    Re: Spreadsheet not calculating

    Increase the number of iterations (same screen where you turn on
    auto-calculate). Increase it to 100 and see if that helps. ed


+ 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