check compatibility issues between versions in Excel

Q135. In my organization different users have different versions of Excel - how do I check compatibility issues with my WorkBook across versions?

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 excel check compatibility issues between excel versions

 

You can find similar Excel Questions and Answer hereunder

1) Vlookup to return multiple values in same cell in Excel

2) I have to make an investment decision - I have the cashflow numbers. In Excel, how do I calculate Internal Rate of Return (IRR)?

3) How to freeze a row or column in Excel

4) How can I activate a routine when there is a change in value of a cell?

5) How can I identify all cells with Data Validation in my WorkSheet?

6) How can I generate random numbers between 2 limits?

7) How can I get input from user through a prompt and assign user's input to a cell?

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

9) How can I find the sum of records that meet a given condition in my raw data table?

10) How can I check if a file exists in a folder using VBA?

11) I track a stock on a daily basis and enter the Open, High, Low and Close values for every trading day. In Excel, how can I automatically get High and Low values for the last 10 trading days?

12) In a Table , how can I remove duplicate records?

13) Is there a way to get a log value of a number using Excel?

14) How can I display list of NAMES in a worksheet?

15) I have a cell with nested formulas that returns an error. In Excel, how can I step through the formulas to help with debugging?