none
How do you turn off compatibility mode in excel?

    질문

  • My app opens automatically in compatibility mode.  How do I turn that off.  I only want to use this when I need it.
    • 이동됨 Jennifer ZhanModerator 2010년 8월 17일 화요일 오전 6:49 (From:Office 2007 Application Compatibility)
    2010년 8월 15일 일요일 오후 6:54

답변

  • 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.

    2010년 8월 17일 화요일 오전 6:48
    중재자

모든 응답

  • 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.

    2010년 8월 17일 화요일 오전 6:48
    중재자
  • 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.

    2012년 6월 7일 목요일 오후 4:12
  • 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.
    • 답변으로 제안됨 Cody2099 2013년 1월 2일 수요일 오후 4:31
    2012년 8월 2일 목요일 오후 10:33
  • 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 

    2014년 4월 10일 목요일 오후 12:53
  • Thanks...........done
    2014년 9월 13일 토요일 오전 4:40