How To Stop Excel Files Opening In Compatibility Mode
- Dec 20, 2016 Manage compatibility mode. Compatibility mode is used automatically to open Word, Excel. The Set default compatibility mode on file creation policy.
- My Excel workbook opens in Compatibility Mode. My Excel 2013 workbook opens in Compatibility Mode. Now when you open the excel file it will not show the.
Excel Tip – Defaulting to Non-Compatibility Mode I was recently fighting with Excel because I was sick of it wanting to run in Compatibility Mode by default. Everything I found out there said that you simply need to change the option for Save-As to be the 2007 format. This only seemed to work on the workbooks I had open.
If I closed and re-opened Excel it would be back in Compatibility Mode. Remembering from my old days of hacking Excel 97 workbooks and creating templates with Macro’s I recalled a way to change the default workbook that Excel would use when starting up. This is where the ‘ah-ha’ happened. Below are the steps you may use to force Excel out of Compatibility Mode when it starts up if changing the aforementioned Save-As method does not work for you. Open Excel (you should get Book1 Compatibility Mode by default). Save-As (F12) and save it as Book1.xlsx (the 2007 format) in the following location: C: Program Files Microsoft Office Office12 XLSTART. Restart Excel That’s it!
Excel by default will look in this location (based on where you installed Excel) for the default workbook it uses when starting up. Since you have saved it in the 2007 format Excel will no longer run in Compatibility Mode by default. It will only do this when opening.xls files that were saved in Compatibility Mode. For those, just save as.xlsx and you should be good. Want to learn more about Excel? Or dive in deeper and learn.
How To Open Excel Files
This tip is WRONG!!!!!!!!!!!! Of course there is a way to do it properly (as others have said above). This is how you do it properly:- 1) Open Excel 2) Click on Office Button ( the coloured one in top left corner) 3) Then in the next window click on Excel Options (bottom right) 4) In next window click on Save (4th one down on left hand side) 5) In next window towards the top where it says “Save files in this format” make sure the box next to it says “Excel Workbook” then click ok at bottom and that’s it. Now when you open Excel 2007 it will not be in compatability mode. Hope that helps! Visualdsp++ 5.0. I am converting excels files from 2003 to 2013, however when I finish converting the files to 2013 version and changing all the links to 2013 version files and save the files verifying that no compatibility issues.
When I open the same file again it come up stating that where are compatibility issue even when all files linked are on version 2013. I have noticed when I open all the linked files is comes up that there are no compatibility issues. Is there a way that the compatibility setting can be set so that I don’t have to open all the files to eliminate the compatibility situation when the file is being opened without going through the process of opening all the linked files any time the file is opened? I found the solution on another website 🙂 You need to create a folder: Put everything related to everything you are going to work on or with, into that folder.
Now open Excel - go to “file” - go to “options” - go to “trust center” - go to “trust center settings” - go to “TRUSTED LOCATIONS” and click Add new location. Where it says Path: write the entire path to the new folder. Check the box beside “Subfolders of this location are also trusted” and click OK. Now close excel. Go to the folder you made, where all your work is. Open the excel file you want to work with and it should be good 😀 Let me know if anything here is unclear.
May 22, 2014 Describes how to resolve the issue where Workbooks are opened in compatibility mode Excel 2010 or Excel 2007. Open an Excel file to confirm the issue.