KB76729972: WebCenter - How to update Cascading drop-downs from modified Excel sheet

Description

Instructions to propagate changes in Excel sheet used for cascading drop-downs to corresponding restricted sets in attribute categories in WebCenter.

Procedure

After you update the Excel sheet follow these steps:

1. Copy the modified Excel document to the WebCenter\WebServer\tomcat\webapps\<WebCenter instance name>\custom\excel folder on the WebCenter Web Server.
2. If you add a new column(s) to the Excel sheet, you need to update the lists.xml file too accordingly. Detailed description can be found here.

Alternative procedure

When editing your Excel sheets defining WebCenter cascading drop-downs regularly it's better to make the update procedure more automatic. To achieve that, follow these steps:

1. Configure a pushthrough folder on your system that automatically move inserted documents to the folder mentioned above. Click here to find out how.
2. Copy your Excel document to the created pushthrough folder.