Formula in MS Excel 1997-2003 workbook doesn’t work properly in Excel 2016

Please help if you can. I have a spreadsheet that I use daily for work (that I made). It was created around 2001 and contains formulas such as A times B equals C. (There are no “IF” statements i...

excel

Joseph_Lizzio

Copper Contributor

Sep 05, 2020

Sergei,

Good morning and thanks for entertaining my inquiry. Upon further analysis that I just performed, I believe the issue has to do with using GoalSeek in 2016. Prior to the upgrade to 2016, when I would solve for a number using GoalSeek in a particular cell, Excel would solve for the result and enter a number in that cell. If I hovered over it afterward, I could still see the formula. No the calculation is done and Excel places a number there while also erasing the formula.

In the cell that that has the problem contains this formula =D$369*Q183.

I’m thinking that there must be a setting that needs to be configured in the spreadsheet that tell Excel not to change the cell format once a calculation is made.

What are your thoughts?

SergeiBaklan

Diamond Contributor

Sep 05, 2020

Joseph_Lizzio

Sorry, I didn't touch GoalSeek for many years. Try to convert the file, perhaps that will help.

Forum Discussion

Formula in MS Excel 1997-2003 workbook doesn’t work properly in Excel 2016