How To Stop Excel Files Opening In Compatibility Mode

Posted on
Download excel files

Our program allows our users to create documents based on templates we have loaded into our program (program is web-based). When they create a new document, it should open in Word, and then they save the document after editing by using an add-in that we created for Word.

The documents are.docx I have one client running on Windows 8, with Office 2013 and using the most recent version of IE; when she opens a new document, it opens in read-only and compatibility mode. Saving the document to her computer would keep our add-in from functioning correctly. I have made sure that the protected view checkboxes are unchecked, which usually fixes this issue. I also tried adding the temporary internet file location to trusted locations.

I made sure that.docx is set to open with Word by default. I have ensured that our website is added to trusted sites in IE and enable protected mode is unchecked. How can we fix this so that the documents do not open in read-only mode? Thank you for your response and update on the current situation. I’ve tried to untick protected view check boxes and open a Word attachment from Outlook, it opened in read-only view.

Before uninstalling Excel 2007, consider to try the following steps: 1. Open Excel 2007 > click on the Office orb. Click on Excel Options > Save. Select ‘Excel workbook’ from the ‘Save files in this format:’ dropdown at the top. Restart Excel. Nikon d800 remote control software. Excel 2003 can also handle Excel 2007 files usingCompatibility Pack.

Seems it’s the default behavior when opening files from Internet. Please refer to the following article: Meanwhile, please let the user check the following options and test the issue again: 1. Trust Center Settings Trusted Locations “Allow Trusted Locations on my network (not recommended)” 2. Trust Center Settings Trusted Documents “Allow documents on a network to be trusted” from the Trust Center Settings. For more information, please refer: Please feel free to post back. Regards, Steve Fan TechNet Community Support.

Hi, Which web-based program are you using to store the templates? Does this issue happen to other users? First, please make sure the templates are not saved with selecting the “Read-only recommended” option. In addition, please save the document to local drive and check if it opened in read-only mode. I have tested in my environment, with the protected view checkboxes unchecked, when I open a file from SharePoint, a window pops up and say “How would you like to open this file?”, so I can choose to open in Read Only mode or Edit mode. What's your situation? Did get any choice to select the mode?

Please feel free to contact me again. Thanks, Steve Fan TechNet Community Support. Thank you for your response and update on the current situation. I’ve tried to untick protected view check boxes and open a Word attachment from Outlook, it opened in read-only view.

Excel Files Opening In Word

Seems it’s the default behavior when opening files from Internet. Please refer to the following article: Meanwhile, please let the user check the following options and test the issue again: 1. Trust Center Settings Trusted Locations “Allow Trusted Locations on my network (not recommended)” 2. Trust Center Settings Trusted Documents “Allow documents on a network to be trusted” from the Trust Center Settings. For more information, please refer: Please feel free to post back.

How To Stop Excel Files Opening In Compatibility Mode

Regards, Steve Fan TechNet Community Support.

Applies to: Office 2016 Topic Last Modified: 2016-12-20 Summary: Introduces compatibility mode in Office and how to set the default behavior for Word. In Office, compatibility mode is used automatically to open Word, Excel, and PowerPoint documents that were created in earlier versions of these applications. Compatibility mode ensures that no new or improved features in Office are available while users work with a document so that people who use earlier versions of Office will have full editing capabilities. Compatibility mode also preserves the layout of the document. You can use the Set default compatibility mode on file creation policy setting to manage the default compatibility mode that Word uses to create new Word documents. This might be necessary if you have add-ins or macros that use the layout functions that are used in Word 2007 or Word 2010.

When you enable this policy setting, you can specify which versions of Word (2003, 2007, 2010, 2013, or 2016) that new Word documents are compatible with. Several configurations options are available for this setting:. Word 2003 This mode disables features in Word that are incompatible with Word 2003. Word 2007 This mode disables features in Word that are incompatible with Word 2007. Word 2010 This mode disables features in Word that are incompatible with Word 2010. Full functionality mode This mode makes sure that all new features remain enabled.

This is the default setting for Word 2013 and Word 2016. When you choose the Word 2003 option, Word is configured to create new Open XML files that have Word 2007, Word 2010, and Word 2013 features disabled. Doing so makes sure that the Open XML files do not contain content that Word 2003 users can't edit. However, users of Office 2003 must still have the Compatibility Pack installed before they can edit Word Open XML files that are compatible with Word 2003. If you select Full functionality mode, there is no effect on the Word 2007 and Word 2010 users. They can open and edit Word 2013 and Word 2016 documents.

Excel Templates

Excel files opening in word

Free Excel Templates

The only difference is that new features in Word 2013 and Word 2016 are not available in Word 2007 or Word 2010. You can download the Office Administrative Templates from the. The Set default compatibility mode on file creation policy setting is located in the path Microsoft Word version Word Options Save. Where version is the version of Word for which you are setting the default compatibility mode. For example: Microsoft Word 2016 Word Options Save.