Is co-authoring possible in tables?

BobBridges · #2 08-11-2021, 07:19 AM

I may have misunderstood you, but it sounds like the same thing I'm doing with an overseas client; they want to be able to update their workbook with fresh data, but they also want me to be able to add VBA code to it.

The obvious way to do that is to have some sort of SharePoint or SharePoint-like arrangement. With SharePoint you have the file in a common location, and if anyone opens it SharePoint marks it as "checked out" to that user; others can look at it, but cannot update it until the other user checks it back in.

In my case the client is unwilling to give me access to their SharePoint space, so we make do with a workaround: They send me the latest copy, upon which I announce to them that I have it "checked out" and they must remember not to update their copy until I send them my updates, at which point it's back in their hands again. Not entirely satisfactory, but it seems to work, mostly (I think) because they don't have to update their stuff constantly. If they did, it would be much harder.

To reduce confusion, I'm careful about filenames. When I send them a copy, I name it "name yyyy-mm-dd.xlsm" so there's no doubt about which version is which.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
What are issues with co-authoring	kmcuprys	PowerPoint	0	08-25-2015 01:55 PM
Multi-User Authoring	jimbassett	Word	1	03-26-2015 11:52 PM
Multi-user authoring	jimbassett	Excel	0	03-26-2015 10:13 PM
Disable co-authoring function	lawlsh	Office	0	08-13-2013 08:24 PM
Problem with Word 2010 co authoring	chris200	Word	0	10-11-2011 06:44 AM