You cannot open an IRM protected workbook in Protected View in Excel 2013
სტატია
ვრცელდება შემდეგზე:
Excel 2013
Symptoms
When you try to open an Information Rights Management (IRM) protected Microsoft Excel 97-2003 workbook (.xls file) in Protected View in Excel 2013, the operation fails. Additionally, you receive the following error message:
We found a problem with some content in <file name>. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes.
Workaround
To work around this issue, temporarily disable Protected View in Excel 2013, and then open the workbook again. To disable Protected View in Excel 2013, follow these steps:
In the File tab, click Options.
In the Excel Options dialog box, click Trust Center.
Click Trust Center Settings.
Click Protect View.
In the Trust Center dialog box, clear the following check boxes as appropriate for your situation:
Enable Protected View for files originating from the Internet
Enable Protected View for files located in potentially unsafe locations
Enable Protected View for Outlook attachments
More Information
Protected View is a read-only mode in which most editing functions are disabled. Additionally, Protected View is enabled by default, and files that are located in potentially unsafe locations are opened in Protected View. For more information about Protected View, go to the following Microsoft website:
This module introduces potential ways that people can use Excel and Power BI together. Power BI is a great tool for telling a story through visuals; occasionally, it's beneficial to use Excel for analysis. Excel can make a connection to a Power BI dataset, enabling you to analyze the data by using PivotTables.
There are two types of Information Rights Management (IRM) settings available in Microsoft InfoPath: one for protecting access to InfoPath form templates, and one for controlling access to and actions on form data contained in completed forms.