


Click for more details.", the file didn’t pass file validation. Searching through the net I found that: "File validation failure - When you see a message in Protected View that says "Office has detected a problem with this file. In the new laptop with excel 2016 the file opens, but it only opens in protective view. So, I removed the Calendar ref in a e pc with excel version 2003 and then copied by usb to the other laptop that has excel 2016. The main problem, when trying to make the conversion, was that excel 2016 (and 2010) did not recognise the MS Calendar reference and I could not enable the macros. I have many worksheets, all of which are protected and the VB Project is also Protected. Once you are able to access the document, do not forget to re-enable Protected View settings.Hi, I have recently converted a large excel file with a lot of macros to work in excel 2016. So, we recommend disabling the protected view for one-time only. ‘ Protected View‘ acts as a guard securing your computer from any malware or virus which sometimes gets into your computer with downloaded documents (Email attachments). It will be opened without any issues further. Try to open the document you were having trouble with. Coming back to the Excel Options window, click on “ OK” to save the changes. Then, uncheck the option “ Enable Protected View for files originating from the Internet“.ġ1. After that, on the left-hand side click on “ Protected View“.ĩ. Now, click on “ Trust Center Settings…” to modify it.ħ. In the Excel Options window click on “ Trust Center” to access the Trust Center Settings.Ħ. Then scroll down through the left side of the menu and click on “ Options“.ĥ. When the Excel window opens up, click on “ File” in the menu-bar.Ĥ. Again, click on “ Excel” in the elevated search results to open Microsoft Excel on your computer.ģ. Click on the Search box and then type “ excel“.Ģ. Fix-4 Disable Protected View settings in Excel-ĭisabling the protected view settings from Excel options will solve this issue for your computer.ġ. Fix-2 Tweak excel advanced settingsģ – Click on Advanced from the left side menu.Ĥ – Now, Uncheck the option saying Ignore other applications that use Dynamic data Exchange (DDE)ġ – Open Run command box by pressing Windows key and R key together from your keyboard.Ģ -Now, type excel /safe in it and click OK Go for the other fix if this doesn’t work out.
