How You Make Mass Assignment Changes Using a Spreadsheet

If you need to update many assignments at once, you can download the data from the Verification page into a spreadsheet and make the changes offline.

You need to do these things before downloading the data to a spreadsheet:

• Install the Oracle ADF 11g Desktop Integration desktop client

• Enable the Trust access to the VBA project object setting in Microsoft Excel

If you added any attributes on the Changes page using personalization, they will be hidden when you download the data into a spreadsheet. You can display these attributes using Unhide feature in Microsoft Excel. You can check in and verify the data in the spreadsheet multiple times while making revisions. After the final check in, you need to go to the Review page to submit the changes.

Note: The mass update transaction gets automatically saved when you go to the Verification page. The current changes overwrite the earlier mass update in this process and you can't restore the earlier changes even if you cancel the current transaction