Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-05-2017, 04:53 PM
Logit Logit is offline viewing completed goal seek formula Windows 10 viewing completed goal seek formula Office 2007
Expert
 
Join Date: Jan 2017
Posts: 591
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

Obviously I misunderstood your question. Apologies.



I don't know about clicking or double-clicking the cell but here is a sure fire way to see the Goal Seek window :

On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek.

May not be what you are wanting ... but it's all I know. Perhaps someone else has a better way ?
Reply With Quote
  #2  
Old 03-05-2017, 06:28 PM
katomich katomich is offline viewing completed goal seek formula Windows 10 viewing completed goal seek formula Office 2016
Novice
viewing completed goal seek formula
 
Join Date: Mar 2017
Posts: 4
katomich is on a distinguished road
Default

Quote:
Originally Posted by Logit View Post
Obviously I misunderstood your question. Apologies.

I don't know about clicking or double-clicking the cell but here is a sure fire way to see the Goal Seek window :

On the Data tab, in the Data Tools group, click What-If Analysis, and then click Goal Seek.

May not be what you are wanting ... but it's all I know. Perhaps someone else has a better way ?
Thank you again for the reply, but I already tried this. Please look at example (e.g. test) file I send and look at the cells I referenced. When I followed the steps you mentioned, it give me a clean goal seek dialogue box and does not show the goal seek that was previously entered.
Reply With Quote
  #3  
Old 03-05-2017, 06:45 PM
jeffreybrown jeffreybrown is offline viewing completed goal seek formula Windows Vista viewing completed goal seek formula Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
Default

Quote:
Originally Posted by katomich View Post
When I followed the steps you mentioned, it give me a clean goal seek dialogue box and does not show the goal seek that was previously entered.
I think you are always going to get a clean goal seek dialogue box when selecting goal seek again.

At least from what I understand, that's the purpose of goal seek. Seek out a solution an Excel presents that result.

Like Logit, not really sure what you are tying to achieve. Hope I helped at all...
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
viewing completed goal seek formula How many more surveys needed to reach certain goal jenreindunca Excel 1 01-29-2017 07:06 AM
viewing completed goal seek formula VBA with goal seek takes too long Stata15 Excel Programming 3 07-22-2015 12:22 AM
Automatic goal seek program-Help required calltobala Excel Programming 0 05-08-2015 08:41 AM
Excel VBA Multiple Automatic Goal Seek Required – Please Assist us champaben Excel Programming 13 06-22-2014 05:54 AM
viewing completed goal seek formula Adding a goal line to a chart uhlersa Excel 1 01-16-2012 08:18 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:08 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft