Clear Cache for a List of Values

A list of values' choices are always cached in the workbook.

The cache for a list of values based on a business object can contain up to 300 items, plus all used items. It is populated during the first download or the first time the search-and-select window is used. The search-and-select window shows the cached list of values, if available. An upload also uses cached data.

As a workbook developer, remember to click Clear List of Values Cache from the Advanced menu:

• Whenever you change any list of values configuration, and always when you publish the workbook
• When the service host is changed.
• When cached data is not what the user expects.