Almost everyone in our business has Microsoft Excel on their computers or laptops, it is one of the most used tools in the corporate world and sometimes, without any secret, PPM Workbench can be tedious to open or hard to understand.

Now we have a feature to edit and change de list validations in Excel, you can add some new values, edit, or delete them. It is called “Edit list validation values” and you can find it under Open > Administration > Edit List Validation Values. 

You can choose from a list of validations which one you want to Edit, then you will get the excel file with the list values for the validations, you can open the file in Excel and do the modifications to the values. It is recommended to save it with a different version once you are going to perform any change, another recommendation is to start doing the changes in DEV, that way you can perform tests in the lower environments before implementing them in production.

One of the advantages of this feature is that you can save the modified file on your computer and you can use the same file to import it in the upper environments, once you have all the changes ready.

All you need to do is go to Open > Administration > Edit List Validation Values, as mentioned before, then you will get the screen to pick the validation you want to edit.

After that, you must click on “Download as Excel File”, to get the validation information in excel format.

There you can add, delete, or modify the values and save the file into your laptop. Then once you finish with the changes you upload it or drop it into the previous page, in the following space,

And that will be the process to change a list validation using Excel.

What a nice feature, isn't it? 

Thanks,

Randall