Check compatibility issues between versions in Excel

To do it in Excel, here is the answer:

a) Click on "Info" under "File". Click on "Check Compatibility" under "Check for Issues".

excel check compatibility issues between excel versions

b) A new message window "Compatibility Checker" pops up with a report of compatibility issues of the WorkBook with prior versions.

Review the report and take appropriate actions.

excel check compatibility issues between excel versions

 

You can find similar Excel Questions and Answer hereunder

1) I am not able to use VLOOKUP as the lookup value column is to the right of the column that has the information I need. Is there an alternative option?

2) Generate a list of unique values in Excel

3) Here an explanation about text box and how to control text boxes in Excel VBA

4) How to convert a number or string into a data with the cdate function

5) How can I find the count of records that meet multiple conditions in my raw data table?

6) How can I see where page breaks occur before actually printing?

7) How do I enter a formula in a cell using VBA (using Absolute Reference)?

8) How can I find time interval between 2 times?

9) How can I remove hyperlinks from a range of cells?

10) How can I find number of months that has elapsed given 2 dates?

 

Here the previous and next chapter