Indicates whether to hold changes to the data in memory until the connection is closed.

Syntax

Connect-Excel -BufferChanges bool

Data Type

bool

Default Value

true

Remarks

Indicates whether to hold changes to the data in memory until the connection is closed. Setting this to false will write the changes immediately but there will be a performance hit when issuing lots of requests as the file must be opened and closed repeatedly.