User Profile
u144175
Copper Contributor
Joined Jun 06, 2021
User Widgets
Recent Discussions
Re: Issue with Goal Seek suddenly not working - June 6, 2021
It comes and go with different data / workbooks. When I first experienced the issue, it was within a large workbook I use virtually every day. That's when I created the simple example sheet I provided in my original post above to illustrate the situation. A week or two later, the issue went away and goal seek was working correctly again. Everything seemed ok until about a week ago and then I once again saw the same behavior, this time in a workbook that I only use occasionally (about once a month). Different workbook but same incorrect goal seek behavior. I did not attempt to use solver instead of goal seek. Goal seek is presently working again so any troubleshooting is moot right now however I will try solver and safe mode if/when I again see the aberrant goal seek behavior. Thanks for the suggestions on this very odd, intermittent issue. I do appreciate the help.23KViews0likes1CommentIssue with Goal Seek suddenly not working - June 6, 2021
I am suddenly having an issue with Goal Seek not working correctly. I have successfully used it many, many times in the past and cannot begin to figure out what has happened. The issue first came to light within a spreadsheet much to complicated to describe here but I created a new workbook with just this limited data to illustrate the issue. Cell A1 = 1. Cell A2 = 2. Cell A3 = 8. Cell A4 = Average(A1:A3), which correctly shows as 3.66667. Now, I run Goal Seek and tell it to set cell A4 to a value of 10 by changing cell A2. Rather than Goal Seek iterating on cell A2 to determine the value of 21 necessary in that cell to achieve a value of 10 in cell A4, it iterates cell A4 and eventually "finds" a solution of 10 in A4. So, it has 1.) iterated on the wrong cell and 2.) replaced my =average(A1:A3) formula in cell A4 with a value of 10. What is going on? I am attaching screen grabs of the before Goal Seek, the Goal Seek setup, and the after Goal Seek. (Note, in the 'after' screen grab, A4 still shows to be a formula equal to =Average(A1:A3) but that is just because I had not closed the Goal Seek window yet. Once that is done, the formula is replaced by the number 10. The replacement occurs even if I click Cancel which would normally forget the Goal Seek results and revert the cell that was iterated on back to its original value.) I am using Microsoft Office Professional Plus 2019, Excel version 2105, Build 14026.20246. Thank you in advance for any assistance on this very odd issue that is driving me crazy. Brian25KViews0likes9Comments
Recent Blog Articles
No content to show