Forum Discussion
Goal seek not giving the answer
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
HansVogelaar Hey hans, thx for quick response. I was not able to attach a picture or a file, but I have uploaded it to paste.pics where it is public. I just made a simple equation example, where you can see it doesn't show the solution, only that it has found one.
https://paste.pics/9874fb69b0ed7fb348eb55428a1d8e8f
Thx for your help
Thanks for sending the workbook in a private message.
Goal Seek works correctly in Excel for Windows, although it takes a very long time to solve this simple problem.
I will attach the workbook here. I hope that someone else with a Mac will see it and test it.
I am also having an issue with goal seek. Not sure if you'd prefer this be a new thread, but when I try running it, it doesn't seem to start. I just get a message that a solution was found yet current value stays where it was before starting goal seek. I thought it could have been related to the option of allowing curricular reference errors (set the iterations allowed to 2). But after turning that off, the error remained. Also tried restarting Excel.
(tried to add the screenshot, but the image insertion didn't work)
I get this:
Could you send me a sample workbook in a private message? (Click on my user picture and click Message)
