Share via

Compatibility between Excel 2007 and 2016.

Anonymous
2016-07-21T10:24:33+00:00

Hi all,

We have been migrating to Office 2016 in the company, but there's still lot of users with the 2007 version. One of the migrated users reports that they have an excel file with no complex formules, working perfectly with 2007 version, but when opened with 2016 lots of cells show the #value! error. I've checked the formules and theres only references to data inside the book, no external references. 

Any idea? 

Thanks in advance!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2016-07-21T11:12:27+00:00

    Hi, Bernard!

    Thanks for the answer. The problem is solved, it was related to the decimal separator, in one system it was configured with the comma (,) and the other was configured with the point (.)

    Thank you very much for taking time to answer this silly kind of questions :D

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-07-21T10:57:00+00:00

    A workbook developed with Excel 2007 should give exactly the same values when opened in Excel 2016.

    The other way (made in 2016, viewed in 2007) could have problems if new functions have been used.

    I suggest the user repairs Office.

    https://support.office.com/en-us/article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b?CorrelationId=19208c33-3b40-4c56-9b0c-bf7a8191c7a5&ui=en-US&rs=en-US&ad=US

    best wishes

    0 comments