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 connector are applied when the connector'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.