Support Article
Unable to edit in Excel with LDAP authentication
SA-12237
Summary
When connecting to the system using LDAP authentication, which goes through a WebSEAL reverse proxy, users are unable to edit content exported to Excel.
Error Messages
Unable to download prexcelgenerictemplate.biw
Steps to Reproduce
Attempt to export to Excel to edit content.
Root Cause
The root cause of this problem is defect or misconfiguration in the operating environment. The cookie attribute "httponly" prevents sharing of cookie information with other processes. This prevents the Office integration from working properly.
Resolution
The explanation for this behavior is as follows:
Refer SA-8817 for a detailed description of this issue: https://pdn.pega.com/support-articles/error-when-trying-edit-data-table-excel
Remove the "httponly" cookie attribute. However, this may not be appropriate for a fully secured application as this is a valid cross-site scripting (XSS) security measure. In such systems, provide an alternative method to edit content.
Published May 23, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.