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

%3CLINGO-SUB%20id%3D%22lingo-sub-1637993%22%20slang%3D%22en-US%22%3EFormula%20in%20MS%20Excel%201997-2003%20workbook%20doesn%E2%80%99t%20work%20properly%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1637993%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20help%20if%20you%20can.%20%26nbsp%3B%20I%20have%20a%20spreadsheet%20that%20I%20use%20daily%20for%20work%20(that%20I%20made).%20%26nbsp%3BIt%20was%20created%20around%202001%20and%20contains%20formulas%20such%20as%20A%20times%20B%20equals%20C.%20%26nbsp%3B%20(There%20are%20no%20%E2%80%9CIF%E2%80%9D%20statements%20involved).%20The%20sheet%20has%20been%20working%20fine%20for%20years.%20%26nbsp%3BThis%20week%20my%20firm%20decided%20to%20do%20an%20upgrade%20on%20my%20workstation.%20%26nbsp%3BThey%20upgraded%20the%20operating%20system%20up%20to%20Windows%2010%20from%207%20and%20MS%20Excel%20from%20the%202010%20version%20to%202016.%20%26nbsp%3B%20Now%20much%20to%20my%20surprise%20the%20formulas%20in%20my%20spreadsheet%20do%20work.%20%26nbsp%3B%20It%E2%80%99s%20the%20strangest%20thing%20and%20I%20haven%E2%80%99t%20a%20clue%20why%20this%20is%20happening.%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20thoughts%20you%20might%20have%20would%20be%20greatly%20appreciated.%20%26nbsp%3BThanks.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJoe%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1637993%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1638014%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20in%20MS%20Excel%201997-2003%20workbook%20doesn%E2%80%99t%20work%20properly%20in%20Excel%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1638014%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F783066%22%20target%3D%22_blank%22%3E%40Joseph_Lizzio%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ECould%20you%20please%20give%20bit%20more%20details%20-%20formulas%20don't%20work%20at%20all%2C%20or%20they%20return%20wrong%20result%2C%20or%20what%3F%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20try%20to%20convert%20your%20file%20in%20File-%26gt%3BInfo%20into%20compatible%20format%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20737px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F216741i961FC97522816AC6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20do%20that%20on%20copy%20of%20your%20file.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 involved). The sheet has been working fine for years.  This week my firm decided to do an upgrade on my workstation.  They upgraded the operating system up to Windows 10 from 7 and MS Excel from the 2010 version to 2016.   Now much to my surprise the formulas in my spreadsheet do work.   It’s the strangest thing and I haven’t a clue why this is happening.  

 

Any thoughts you might have would be greatly appreciated.  Thanks. 

 

Joe

 

3 Replies

@Joseph_Lizzio 

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

image.png

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? 

@Joseph_Lizzio 

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