locked
How do you turn off compatibility mode in excel? RRS feed

  • Question

  • My app opens automatically in compatibility mode.  How do I turn that off.  I only want to use this when I need it.
    • Moved by Jennifer Zhan Tuesday, August 17, 2010 6:49 AM (From:Office 2007 Application Compatibility)
    Sunday, August 15, 2010 6:54 PM

Answers

  • Hi,

    Compatability mode is there to ensure your spreadsheet is compatable with prior versions of excel. In Excel 2007 you be in Compatibility mode when you open a Excel 97-2003 xls workbook.

    Try saving as a .xlsx format (2007 xml based) and you will not lose the settings. IN doing so users with prior versions will not be able to open the document without losing the any formating or features not backward compatible.

    Change the default file format to one of the 2007 formats and you will not see it.

    • Marked as answer by Jennifer Zhan Monday, August 23, 2010 2:25 AM
    Tuesday, August 17, 2010 6:48 AM

All replies

  • Hi,

    Compatability mode is there to ensure your spreadsheet is compatable with prior versions of excel. In Excel 2007 you be in Compatibility mode when you open a Excel 97-2003 xls workbook.

    Try saving as a .xlsx format (2007 xml based) and you will not lose the settings. IN doing so users with prior versions will not be able to open the document without losing the any formating or features not backward compatible.

    Change the default file format to one of the 2007 formats and you will not see it.

    • Marked as answer by Jennifer Zhan Monday, August 23, 2010 2:25 AM
    Tuesday, August 17, 2010 6:48 AM
  • Can you please be more specific??? It's not at all clear from your response what one is supposed to do.

    I'm in Excel 2010 and would like to use Sparklines but can't figure out how to turn off compatibility mode.

    Thursday, June 7, 2012 4:12 PM
  • After I saved my doc as .xlsx I have to close it and reopen it for the compatibility mode to turn off and make the sparklines appear. Hope this helps.
    • Proposed as answer by Cody2099 Wednesday, January 2, 2013 4:31 PM
    Thursday, August 2, 2012 10:33 PM
  • Just found this on Google so appreciate post is from 2010 but no-one seems to have mentioned that if you go to File -> Info there is a 'convert' option which you can use to convert from 2003 to 2010 without having to re-save manually yourself. It'll come up with a message saying 'do you want to re-open now?', click yes and you'll have a 2010 version of your workbook with no compatability mode.

    I don't think you can turn it off, but it'll stop being a problem once everyone starts using office 2010 anyway which now office 2003 support is ending should be soon, one would hope 

    Thursday, April 10, 2014 12:53 PM
  • Thanks...........done
    Saturday, September 13, 2014 4:40 AM
  • go to file ==> options ==> save ==> save files in this format choose Excel Workbook. Click OK

    That'll do it!

    • Proposed as answer by Rray C Thursday, April 9, 2015 8:21 PM
    Thursday, April 9, 2015 8:20 PM
  • Thank you for your valuable information 

    Thursday, July 21, 2016 11:35 AM
  • For 2016 - Click on File>Info>Check for Issue (Inspect Workbook)>Check Compatibility. Click the drop down on Select Versions to show, unselect everything except 2016 then click OK. The file name at the top should no longer say compatibility mode.
    • Edited by pbates67 Friday, December 2, 2016 10:11 PM
    • Proposed as answer by robinwilson16 Wednesday, February 28, 2018 8:07 PM
    Friday, December 2, 2016 10:10 PM
  • Whatever You said worked to me. Thanks for your reply.
    Monday, March 27, 2017 5:40 PM
  • This works as listed above. File, Convert (the first option box to your right)
    Tuesday, April 4, 2017 2:48 PM
  • "

    How do you turn off compatibility mode in excel?

    Right click on Excel shortcut or Excel file -> Click Properties -> Tab Compatibility  -> Change Setting for All Users ->  Remove tick  from "Run this program in compatibility mode for"  -> Apply -> Ok ->. 

    Tuesday, October 17, 2017 5:50 AM
  • Does anyone know how to do this for Mac? and with office 365 excel?
    Wednesday, January 31, 2018 2:46 PM
  • Thank you for your valuable information

    saved my  problem

    Monday, January 7, 2019 4:20 AM