Hello,

I'm looking to find a way of having a workbook editable simultaneously by different users.
Excel online allows this but doesn't seem to support any vba or udf connection to an Access database, both of which are used in the workbook.

Traditional workbook sharing never worked well, but I've heard O365 has some collaboration aspect which might achieve this. I've looked around online but haven't found anything explaining what's required or how to set this up. Our IT department are suspicious and clueless so I'd need to provide every nitty detail.

Any help would be much appreciated.