Forum Discussion
Formula in MS Excel 1997-2003 workbook doesn’t work properly in Excel 2016
Could you please give bit more details - formulas don't work at all, or they return wrong result, or what?
You may try to convert your file in File->Info into compatible format
Please do that on copy of your file.
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?
Sorry, I didn't touch GoalSeek for many years. Try to convert the file, perhaps that will help.