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:
Copy the modified Excel document to the WebCenter\WebServer\tomcat\webapps\<WebCenter instance name>\custom\excelfolder on the WebCenter Web Server.
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:
Configure a pushthrough folder on your system that automatically move inserted documents to the folder mentioned above. Click here to find out how.
Copy your Excel document to the created pushthrough folder.
Info
The cascading drop-downs will be updated every time you copy a new version of the Excel sheet to the pushthrough folder.
When you add/remove a column from Excel sheet don't forget to update the lists.xml too and upload it to the pushthrough folder as well.