All Collections
Excel Data Management for Salesforce
FAQ
How-To: Disable caching for picklist values
How-To: Disable caching for picklist values

XLSF | Learn how to turn off caching of picklist values and set it as a real-time lookup

Updated over a week ago

CloudExtend Excel caches picklist values. For 99% of use cases, this is desired as picklist values do not generally change all that often and when they do users can click the ellipse and refresh to quickly cache the values for the session.

For users whose picklist values also change in near real-time, they may elect to disable caching for that field.

Cautionary Note

⚠️ Forcing picklist values to real-time lookup will have a negative impact on performance both during data entry and during an upsert process because each line will be forced to check the value in real-time against Salesforce. Before upserting consider changing the value to the internal ID using [[nnnn]] format.

Enable real-time lookup

To force a field to resolve directly from Salesforce instead of cache, you need to edit the formula in the first row (note this formula is typically hidden by using a white font) and change the &4 to &20.

In addition, this setting will not save back to the template so users will either need to change it each time they load the template or simply save the template on a worksheet for reuse.


​Example:

Old value

= T(N("TimeBill.employee"&4))

New value

= T(N("TimeBill.employee"&20))
Did this answer your question?