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

Validation error pops up on each row of Excel (Edit in Excel)

SA-12739

Summary



Validation error pops up on each row of excel (while using Edit in Excel). When excel is used to load the data table, the validation errors pop up for each row individually rather than validating all the rows and throwing a final pop-up with error messages. Closing pop-up on each row validation is an overhead for the user.

Error Messages



Not Applicable

Steps to Reproduce



1. Create a repeat grid in a section.
2. Configure an icon which launches an Excel where the data can be edited.
3. When rows are edited, there is a pop up window which appears for the validation of every row.

Root Cause



The root cause of the issue is that the macros configured for the excel throw a separate error for each column.

Resolution



The issue is not a bug, however, it is causing overhead for the user by showing a separate error pop up for each row. An enhancement request (FDBK-12070) is raised to address this issue.

Published August 12, 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