Unable to use Excel to edit a Decision Table
Unable to use "Edit in Excel" functionality for Decision Tables
Two issues are found during the course of this investigation:
Users with Internet Explorer 11 are able to edit the contents of the Decision Table in Excel. On saving the Excel sheet, the changes are not reflected in the rule.
A popup error which results in a blank Excel sheet loading.
Issue 2Switching to NOTEPAD.EXE. There was an error launching
application associated with '.xls' file type. To troubleshoot, find
any file of this type using 'File Explorer', right-click, make sure
'open' action exists in the popup menu, select it, check that your
associated editor works cleanly.
Steps to Reproduce
- Open a Decision Table rule for editing.
- Click "Edit in Excel".
- (Applies to Issue 1 only) Make changes to the Excel sheet, save and return to the Decision Table rule form.
The root cause of this problem is a defect in Pegasystems’ code/rules. In IE8, IE9, and IE10 versions, explicit event listeners for openauthoring are not required whereas IE11 mandated it.
The root cause of this problem is a misconfiguration in Internet Explorer
install HFIX-22815 which adds the required event listeners for the openauthoring control in pzActiveXUtilForDecisionTableAndMapValueRuleForms JS file and attaches to the ruleform.
Delete Temporary Internet Files and disable the IE setting, "Enable Protected Mode", on the "Internet Options" > "Security" tab.
PDN article: http://pdn.pega.com/node/1824
details further information on IE Protected Mode.
Published August 3, 2015 - Updated October 8, 2020