+ Reply to Thread
Results 1 to 1 of 1

GOAL SEEK NOT putting Target value on worksheet

  1. #1
    Valued Forum Contributor gjlindn's Avatar
    Join Date
    08-01-2011
    Location
    Dodgeville, WI
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    369

    Question GOAL SEEK NOT putting Target value on worksheet

    I have several users of Excel 2003 reporting that the GOAL SEEK function will not populate the target cell with the proposed solution. In otherwords, the first form pops up where the user can fill the 3 criterea cells (Set Cell, To Value, By changing cell) and click OK. They click OK and the next form appears (Goal Seek Status), which does display the correct Target Value (the Set Cell value), but when they Click OK again, it does not transfer to the worksheet target cell. I've witnessed this myself twice with different users. Restarting Excel does correct the issue, but I'm hoping to understand the cause. A couple of other points I should make: Calculations are set to Automatic and all other Excel options are set to their default values. I've searched many forums and have so far not seen a solution. I'm starting to think an addin Goal Seek replacement form may be the best choice. Thoughts?
    Last edited by gjlindn; 08-04-2011 at 08:24 PM.
    -Greg If this is helpful, pls click Star icon in lower left corner

+ 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