For extracting values and formulas from Excel file when repair file is unsuccessful. What happens to add-ins in Protected View? There are several ways to get around this issue: Recommended The simplest and most secure method to get around this issue is to simply click the Enable Editing button, on a per-document basis, when you open an Excel or other Microsoft office file that has been downloaded. Just for your edification I've included links to three screenshots. Posting here in case anyone else experiences this issue. If the file seems suspicious, close the file and delete it from your computer. Despite it, always create a valid backup of your crucial Excel data and as well scan your system with good antivirus program for virus and malware infection.
An alternative to adding the key, might be to go to the File Block Setting in the Trust Center, and un-check any old file types that may be checked off. Once you are done, You can enable the protected view. You may share your valuable feedback for this on the below support links - Should you have any additional queries, please let me know. Update your office as well as Windows 10 to latest patches from Microsoft site. Well, facing Excel issues and errors is a common problem and once a while every user faces it, so in this case, remember to get on the root of the issue as this help you resolve 50 percent of the error.
When I click on excel files located on network shares the application begins to startup and then freezes for a time before finishing opening the file. Windows Explorer reads the contents of the files in the folder to obtain the additional details. You may also want to disable it for files originating from the Internet. Sometimes, this is caused due to excel not being able to access the default printer. Protected View is a read-only mode where most editing functions are disabled.
BitDefender, for example, has content on adding application exclusions here:. If you don't have license keys, please do not attemp re-installation. A problem was detected with my file Office found a problem with your file and it might be a security risk. With the help of this, you can fix all s ort of issues, corruption, errors in Excel workbooks. For information on how to Activate Office, see:. We recommend you only edit the document if you trust its contents.
Look into to this and see if this helps. Permissions beyond the scope of this license may be available at. To help protect your computer, files from these potentially unsafe locations are opened in Protected View. Coded workbooks are usually used by a lot of people, and then suddenly production halts. Similarly you will need to disable 'Refresh data when opening the file' and possibly also for background refresh.
If yes, then start Excel normally and disable add-ins one by one and start Excel again every time you disable an add-in to determine the culprit add-in. You may login to Windows with a new user profile and see if it helps. Where is the file located? In the Path box, type the name of the folder that you want to use as a trusted location, or click Browse to locate the folder. Important: We recommended that you don't make your entire Documents or My Documents folder a trusted location. Removing workbook protection allows data to be refreshed.
By using Protected View, you can read a file and see its contents and enable editing while reducing the risks. Just make sure to remove or scramble all the sensitive or private data before sharing your workbook. It started on or about April 4, 2018. Provide details and share your research! This article was last reviewed by Ben on June 21st, 2018 as a result of your comments. Microsoft keeping releasing Office and Windows 10 patches to correct known errors.
You may need to check with your antivirus provider to learn how to adjust these settings. We have no idea as why this happens but luckily there is an easy workaround to fix this issue and open your office files like before! Unless you need to edit, it's safer to stay in Protected View. However, if you need to navigate through a document in Protected View with a screen reader, you can press F7 to turn on caret browsing. Are you saying that you have a query that cannot be refreshed with an older Excel version anymore? Caution: We recommend you only do this if the file's source and content are trusted by you. So, these are some of the common reasons related to the error.
Hi, We understand how you feel about the situation. Unless you trust this person and want to continue collaborating with them, it is safer to stay in Protected View. With Excel 2010 I am unable to open the file, even though I've unchecked all of the Protected View settings. Word will try to substitute another font that will hopefully look okay. Click Protect Workbook in the same location and type password to unprotect workbook structure and windows. I am currently using Excel 2016.