Specifies whether to wait until the connection is closed to apply changes made to workbook data.

Data Type

bool

Default Value

true

Remarks

If this connection property is set to True, changes made to workbook data via the provider are applied when the provider's connection is closed.

If this connection property is set to False, changes are reflected in the affected workbook files immediately, though the repeated opening and closing of workbook files necessary to make these immediate updates causes a reduction in query performance.