Skip to main content


         This documentation site is for previous versions. Visit our new documentation site for current releases.      
 

Use case 3.3: Managing edit (in Microsoft Excel)

Updated on April 23, 2021

This functionality allows for updating multiple codes using the Edit (in Excel) feature. This feature is available with 32-bit version of Excel.

Pega Foundation for Healthcare
To use this functionality, complete the following steps:
  1. Repeat steps 1 through 3 of Use case 1: Search codes in a codeset.
  2. Review code set data.
  3. Select Actions > Edit > Export to download the file to be edited in Excel.
  4. Make necessary data changes to the rows of data in the downloaded file without making any changes to columns and column formats.

    Save the file locally for importing back into the application. Maintain the csv format.

    Note: When the codeset file is exported it has date fields with format dd-mm-yyyy hh:mm that needs to change to format dd/mm/yyyy while importing the date fields.
    1. Select Actions > Edit > Import to upload the updated file.
    2. Select the updated file and click Upload.

      The system prompts to upload the data records with a summary of updates.

    3. Click OK to submit the updates to the system. The system saves the changes to the code set file.

Have a question? Get answers now.

Visit the Support 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.com is not optimized for Internet Explorer. For the optimal experience, please use:

Close Deprecation Notice
Contact us