How do you turn off compatibility mode in excel?

Answered How do you turn off compatibility mode in excel?

  • 2010년 8월 15일 일요일 오후 6:54
     
     
    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월 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.

  • 2012년 6월 7일 목요일 오후 4:12
     
     

    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년 8월 2일 목요일 오후 10:33
     
     제안된 답변
    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
    •