I cannot get out of compatibility mode in Excel 2007. I've tried resaving the document but that doesn't help. Thoughts?
Compatibility mode is there automatically if you open an older Excel document.
Do not just re-save, but re-save it as an Excel 2007 document (you will know as it has the extension .xlsx).
When you re-save, it will automatically switch out of compatibility mode.
View excel options --> Save (Excel options are available by selecting the drop down on the window title and selecting "more commands")
Set the "Save files in this format" to Excel workbook (*.xlsx)
If that doesn't work, go to resources and click "diagnose Microsoft office"