Support Article
Unable to save edits to decision table from Excel
SA-24901
Summary
When a user opens a decision table in Excel for editing it opens properly. However, when the Excel file is saved it does not send the data back to Pega.
Error Messages
Not applicable.
Steps to Reproduce
- Edit a decision table rule in Excel.
- Save the Excel sheet.
Root Cause
A defect or configuration issue in the operating environment. Macros were not enabled properly.
Resolution
- Change the Excel trust center settings for macros to "Disable all macros except digitally signed macros"
- Start IE, open Pega, and edit a rule in Excel.
- Once Excel opens, trust the Pega certificate by clicking on the "Enable Content" button.
Click Enable Content > Advanced:
4. Select the "Trust all documents from this publisher" option.
Published June 30, 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.