M365 Shared file or Co-Authored?

[SandsB]

We use Office 365. Every day, we pull a file of all open tickets. Then, each of us makes a copy of that file with just our own tickets. What's the best way for us all to be able to keep open and modify just the one master file all day long? We'd each need to be able to run some macros that work on the individual files now.

 

[GlennUK]

Am also interested on what people advise on this.

 

[BadgerRoad]

I have been using Office 365 and the Shared File feature quite successfully. I do have macros in the spreadsheet and they work on some installations and not others. I haven't figured out which settings allow them to work and which don't.

 

[Skyybot]

I believe co-authoring is the way you want to go. Macros work on individual instances and are Saved as Author Changes.