Question: how to put an excel spreadsheet into compatibility mode?
Answer: Click File > Info > Check for Issues.
Choose Check Compatibility.
To check for compatibility automatically from now on, check the Check compatibility when saving this workbook box. Tip: You can also specify the versions of Excel that you want to include when you check for compatibility.