Persistent Caching Workstation Default

To make persistent caching (read and write) the default for all workbooks on a workstation, edit e1oc.ini and add an entry under the Preferences like the following:

[Preferences]

PersistentCache=2

The location of the e1oc.ini file depends on your installation of Windows. If you are unsure of the location, you can find it by running the System Information report and looking for Configuration File under the Application section.

The following table of values indicates which persistent cache settings correspond to which numeric values:

Value	Setting
0	None – Caching is off. This is the default setting unless you specify otherwise.
1	Read Only
2	Read and Write
3	Write Only
Other	Use the default of None

A complete explanation of each setting can be found in the Office Connector online help.

Additional Notes

• The workstation default establishes the cache setting when you save a new workbook.
• The cache setting for a workbook that has already been saved takes precedence over the workstation default.
• You can override the workstation default by editing preferences and specifying a cache setting on the This Workbook tab.

If you create a new Office Connector workbook, your workstation default will be saved with the workbook. The saved setting will then apply when other users open it, regardless of their workstation default setting.