Disable "Enable Editing" in excel through Aspose

Aspose.Cells Product Family
1

Hi,


Is there any possibility at all to disable “Enable Editing” bar which shows up in excel(2013) through aspose.

In our pivot grid, no data is displayed until user clicks on “Enable Editing”.

I know its an excel trust setting but just wanted to know if there is an option from aspose side.



Thanks in advance
Anil
2

Hi Anil,


Thank you for contacting Aspose support.

Protected View (or “Enable Editing” button) is basically a defensive mechanism offered by Microsoft’s Office applications to defend the machines against the viruses. Please note, the Protected View is normally triggered when an internet downloaded documents are loaded in Office applications including Excel. Whereas, Aspose.Cells APIs are not responsible for triggering this view nor is capable of controlling it in any way.

You can turn off the Protected View using the Options => Trust Center => Trust Center Settings within the Excel application. Please check the attached snapshots for better elaboration. Moreover, if you search on internet, you will find more detailed tutorials on adding specific directories and originating URLs to the white list for the Protected View settings.