Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Inconsistency during multiple editions of MapValue Excel



User performs  'Edit in Excel' to update values in a MapValue. Excel launches and is editable, but when saving the spreadsheet, the values are not updated in Pega 7.1.6. 

Error Messages

No error message.

Steps to Reproduce

    1. Open a MapValue rule.
    2. Try to modify the excel.
    3. Save the document.

Root Cause

User was doing a bulk copy and save of records from one file (Excel) to another (parent Excel), and was inserting on the last row, due to which the column or row structure was getting disoriented, and hence the changes were not getting committed. Moreover, after the copy or paste event, user was closing the Excel before Saving it. Therefore, the changes were not reflecting on the MapValue rule.


Perform the following local-change: 

1. Whenever a record is to pasted on the last row of Excel, it is adviced to first add an empty row, and then paste the data.

2. Ensure that before closing the Excel, the changes have been saved (either using the Save icon or doing Ctrl+S on Excel).

This ensures that the MapValue rule gets updated with the modifications.

Published October 16, 2015 - Updated October 8, 2020

Was this useful?

0% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

Want to help us improve this content?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us