Edit

Share via

Workbook.ConflictResolution property (Excel)

  • Article

Returns or sets the way conflicts are to be resolved whenever a shared workbook is updated. Read/write XlSaveConflictResolution.

Syntax

expression.ConflictResolution

expression A variable that represents a Workbook object.

Example

This example causes the local user's changes to be accepted whenever there's a conflict in the shared workbook.

ActiveWorkbook.ConflictResolution = xlLocalSessionChanges

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.