Excel 2010: Multiple Users


   Trying to find a work around for my predicament.  I have a master workbook in Excel 2010.  This spreadsheet is accessed by three people.  There are some cases where two people may need to be in this spreadsheet.  Is there anyway we could configure the spreadsheet that would allow two people Read/Write permissions as well as not overwrite the other persons changes?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Mal OsborneAlpha GeekCommented:
Yeah, can be done, with a few limitations. Search help for "Share workbook", it is all explained there

Capture.PNG! .
JohnBusiness Consultant (Owner)Commented:
You might consider upgrading these users to Office 2016 as collaboration has been added to Office 2016.
Danny ChildIT ManagerCommented:
File.. Save As.. General Options (at the bottom).. and set a Password To Modify
 - and give this to only one of your users...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Introduction to Web Design

Develop a strong foundation and understanding of web design by learning HTML, CSS, and additional tools to help you develop your own website.

Danny ChildIT ManagerCommented:
by the way, shared files in Excel in the purest sense of the word have always been troublesome in the past.  2016 may be different, but I wouldn't hold my breath...
[ fanpages ]IT Services ConsultantCommented:
by the way, shared files in Excel in the purest sense of the word have always been troublesome in the past.  2016 may be different, but I wouldn't hold my breath...

...As DanCh99 suggested...

[ http://www.experts-exchange.com/questions/28711547/how-to-share-a-workbook-with-vba-project.html#a40963702 ]

It is a widely-held premise, especially with "Experts" at this site, that there are two states of a shared workbook:

a) One that has caused data within it to be corrupted, or
b) One that has not corrupted data... yet.

That said, I have provided (read: had the misfortune to use against my better judgement) shared workbooks to my clients on a number of occasions &, although issues did occur from time-to-time, as long as regular backups of workbook files were taken (usually on an hourly basis), the amount of rework necessary in the event of corruption is kept to a minimum.

The practical usage of shared workbooks is debatable, as they can cause issues in a variety of ways, especially as the number of concurrent users increases.

However, these issues can be reduced or, at least, the frequency of their occurrence can be limited, by writing additional Visual Basic for Application code, or approaching the design of a workbook's implementation (&, hence, code) differently to single/exclusive-use workbooks.

Shared workbooks do have limitations; some of which can be overcome with alternate approaches, but without prior knowledge of exactly what your workbook is doing, it will be difficult to advise you.

Just for background reading or, perhaps for you to understand why you have the problem you described, here is a summary of what features are unavailable (in MS-Excel 2007 & MS-Excel 2010) when a workbook is shared:

[ https://support.office.com/en-ca/article/Use-a-shared-workbook-to-collaborate-49b833c0-873b-48d8-8bf2-c1c59a628534#bmshareworkbook ]
itsmevicAuthor Commented:
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.