I'm having an issue when managing excel files that are imported with protected view active.Scenario: - Upload an excel file with protected view active- Run an action that opens the Workbook (Workbook_Open_BinaryData)- Update the data (not relevant, we can exclue this action)- Get the binary data (Workbook_GetBinaryData) and export the data.When downloading the file, the file it's currupted. However, you can open it, the date is there, but some columns are not correctly formated (date and integer columns)Any ideia about how to solve this issue? I'm currently using the Excel_Package https://www.outsystems.com/forge/component-documentation/1044/excel-package-o11/0Does anyone knows if the same issue happens with Advanced Excel?I was planning to install Advanced Excel to test it, but I got a warning indicates that the modules or extensions with the same key as exists in Advanced Excel will be replaced. I undestood that Advanced Excel will replace Excel_Package.Is this replacement safe or can we have issues?
Thank you!
can you please share more detail like which version of excel you are using ?
As far as Microsoft concern
Workbooks displayed in a Protected View window cannot be edited and are restricted from running active content such as Visual Basic for Applications macros and data connections.
Also can you please share oml and your dummy excel file for testing so it is easy to test and provide solution accordingly.
Hi @Navneet Garg !Microsoft® Excel® for Microsoft 365 MSO (Version 2408 Build 16.0.17928.20336) 64-bit Additinal info: If I open the protected file and simply save it, it works without any issue.Thank you.