Results 1 to 9 of 9

Recalc of circular reference cells after goal seek

Threaded View

  1. #1
    Registered User
    Join Date
    12-28-2012
    Location
    Texas
    MS-Off Ver
    Excel 2003/2007
    Posts
    5

    Recalc of circular reference cells after goal seek

    This question has been unanswered for 11 days and was cross posted here:
    http://www.msofficeforums.com/excel/...goal-seek.html
    This cross post has since been removed

    Original message:

    I just noticed this...

    After using Goal Seek, I must press F9 to recalculate cells with a circular reference, even though Automatic Recalc and Iteration is set in Options. All other cells update as expected, just not those that use circular reference. This is both in Excel 2003 and 2007

    Is this behavior by design?

    Is the only work around to remember to press F9 after every time I use Goal Seek?

    Thanks,

    Todd K.
    Last edited by toddk63; 01-07-2013 at 11:01 AM. Reason: cross post

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