LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tibbs
 
Posts: n/a
Default Goal Seek is REALLY annoying me...


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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Goal seek output Kainoa Excel Discussion (Misc queries) 0 May 22nd 06 09:10 PM
goal seek circular reference etxrmm Excel Discussion (Misc queries) 0 March 16th 06 09:56 AM
Null values in charts and how to override the goal seek functionality Sarge Charts and Charting in Excel 1 January 27th 06 03:57 AM
Goal Seek Mike Excel Worksheet Functions 3 January 23rd 06 04:39 AM
goal seek wont calculate an accurate value past 3 decimal places Joe Browning Excel Discussion (Misc queries) 1 April 13th 05 07:29 AM


All times are GMT +1. The time now is 01:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"