Prevent Error Message "Can´t Merge Your Data" in a Shared Excel File on Sharepoint

[CubaRJ]

Hi,

My company has a large excel file shared on a SharePoint between 20+ people and it very often we have "Can´t merge your data..." making us to rework the change again.

I was wondering if Excel has the ability to "listen" to changes on a shared file so that we can prevent the save until another user has saved their changes on their end and avoid the problem with data merge.

I know there are BeforeRemoteChange and AfterRemoteChange events, but can´t think of how to set it up correctly to trap when a user is updating info and make my code wait or sleep till it is safe to save.


Can you help me?

 

[Micron]

Perhaps set checkout property of the file so that only one user can edit it at a time? Then your vba code can test the CanCheckOut property. If False, someone has it checked out. I'm not a SP person so I don't know how you set that up. I only know that I once had to write code to check out/in a workbook in order to push data to it.