Macro Enabled workbook not syncing properly when more than two users work on it simounteneously

Question

Hi,

We are working with a macro enabled workbook and have some issues when sharing it to other workers to collaborate on it.
The owner of the workbook does not see edits/has the live version of the file, whilst the other collaborators do.
It does work better when opened via sharepoint, but that isn't really a fix, since macros aren't working in sharepoint only in the desktop app.

How can we make sure the document is being live-synced in real time for every user working on it?

Thanks for the help in advance.

Answer 1

Dear Mathis Reichart

Good day! Thank you for posting in Microsoft Community. We are happy to help you.

Based on your description, it seems that Macro Enabled workbook not syncing properly in fiel owner's end when more than one users are collaborating.

If this is your scenario, to help you better and moving forward, we need more detailed information about the situation you are experiencing. Please kindly share with us the information below:

• May I know does all Macro Enabled workbooks have this behavior in the owner's side？Please try to create a new workbook then copy all the content in this affected fie to the new one with the macro to check the result.
• Does the no Macro Enabled workbook have the same result when collaborate？
• Can you tell us your Excel version? Go to File>Account then share the screenshot to us.
• Does only the specific user experienced this situation? Ask other user create a Macro Enabled workbook and share to others to see the result.

We’re looking forward to your reply and will continue to help you all the time!  If there are any misunderstanding or unclear, you can post back in your free time.

Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

Sincerely,

Stacey | Microsoft Community Moderator