Sharing the document

OKearney

New Member
Joined
Jan 4, 2016
Messages
11
I am working on an Excel project that I am trying to make interactive with a group of 30 people. I originally tried doing this on Google Sheets, but that doesn't have specific locking features or the ability to create macros so I have to do it on excel. The problem I am encountering is that I will have one Excel document on a shared network that I am trying to give access to 30 people. They will each have their own tab on that document but they still all need the ability to edit certain aspects of the document at the same time. I know that excel gets fussy when multiple people try to edit the same document at the same time. The most important aspect of this program is that users get immediate feedback. Is there a way to allow 30 people to access and edit the same document?
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,359
Office Version
2013
Platform
Windows
Hi,
Sharing a workbook is generally not advisable – apart from losing some functionality, a shared workbook seldom performs in the manner expected:

http://blog.contextures.com/archives/2008/11/18/avoiding-shared-workbooks-in-excel/


Couple of alternative ideas:

- Make your users worksheets as separate workbooks – these can then be made to read / write to your master workbook which would act as a central database. This would require some reasonably extensive VBA coding.

- look at using Excel Online:

https://support.office.com/en-us/article/Basic-tasks-in-Excel-Online-0dcac23b-8430-4289-87a5-f2c97bdb49e1

Others here may have further suggestions.

Dave
 

OKearney

New Member
Joined
Jan 4, 2016
Messages
11
Would this sort of act like Google Sheets but with the full functions of Excel? Such as VBA coding capabilities?
 

dmt32

Well-known Member
Joined
Jul 3, 2012
Messages
5,359
Office Version
2013
Platform
Windows
Would this sort of act like Google Sheets but with the full functions of Excel? Such as VBA coding capabilities?
The first option your users workbooks would behave as normally with all functionality & they can leave them open all day if needed.

Excel Online cannot really comment as neglected to mention I have little experience with it but others here can give guidance.

Dave
 

Smitty

MrExcel MVP
Joined
May 15, 2003
Messages
29,536
Welcome to the Board!

If you need real multi-user functionality I'd look at Access.
 

Forum statistics

Threads
1,085,840
Messages
5,386,270
Members
401,990
Latest member
Lochlan 1997

Some videos you may like

This Week's Hot Topics

Top