Chris or Tibbs -

When goal seek finds a solution, in the Goal Seek Status dialog box, if you
click OK, the "solution" value appears on the worksheet, but if you click
Cancel, the original values are restored.

- Mike
www.mikemiddleton.com

"Tibbs" wrote in
message ...

Hi all,

I'm using Goal Seek for the first time in ages.

I'm selecting the cell I whose value I want to change, choosing the
cell to alter and typing in the value I'm trying to get to. After a
microsecond of thinking it tells me that it's found the right answer,
but it doesn't put the answer in the cell! All it's doing is telling me
what value next year's sales need to be for me to achieve my required
growth - it's not rocket science or anything!

I'm using Excel 2003 (11.8012.6568) SP2

Is there something really obvious I'm not doing? I have calculation set
to automatic.

Please help, before I beat my computer with something solid...

Chris


--
Tibbs
------------------------------------------------------------------------
Tibbs's Profile:
http://www.excelforum.com/member.php...o&userid=15947
View this thread: http://www.excelforum.com/showthread...hreadid=547149