Forum Discussion
Goal Seek Overwriting Set Cell
- The error appears to be with MorningStar Office's add-in. I disabled it and it worked just fine.
KVPSFA I cannot duplicate the problem with that example. Not too surprising, since I use Excel 2010.
You might have stumbled onto an Office 365 Excel defect that seems to occur from time to time. A google search turns up similar questions as far back as 2017. I don't find any threads with a dispositive explanation.
In any case, it would behoove you to attach an actual Excel file that demonstrates the problem (for you).
And one thing to do: Be sure there are no circular references. Click Formulas > Formula Auditing > Error Checking.
I cannot imagine how that might explain the misbehavior that you report. But when Excel encounters CR errors, "weird things" have been known to happen, even in unrelated cells.
I saw that I'm not the only person with this error, but I'm still a little frustrated with the problem. Hopefully someone at Microsoft can weigh in.
In the meantime, I made a new file, which is attached, where I recreated the issue.
KVPSFA I have MS365 on both PC and Mac. No problem on either of these.
PC version: 2110 (14.509.20000), Beta
Mac version: 1654 (21091405)
I don't have Microsoft 365 but Office 2019 Click-to-Run. I restored the formula in B1, then ran Goal Seek. It worked as intended. Apparently Excel in Office 2019 (which shares most of its code with Excel in Microsoft 365) doesn't have the error.
