Excel shared workbook

Shared excel workbooks:
We have an excel (2013) shared workbook which is updated by one user
When another user access the workbook the data entered by the first user can be wiped out when the workbook is re saved
The workbook is on a network share
Any ideas please
doctorbillTechAsked:
Who is Participating?
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.

Roy CoxGroup Finance ManagerCommented:
Excel is not really designed for multiple users even though you can share the workbooks.

Do you have subscriptions to Office 365 and OneDrive? If so there is a feature called Collaboration that might help.

Collaborate on Excel workbooks at the same time with co-authoring
0
Martin LissOlder than dirtCommented:
Apparently you can collaborate using Excel 2016.
0
doctorbillTechAuthor Commented:
Thanks all - I just saved the workbook as xlsx to solve the issue
0
doctorbillTechAuthor Commented:
Thanks all - I just saved the workbook as xlsx to solve the issue
0

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
Roy CoxGroup Finance ManagerCommented:
How did that solve the issue?
0
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 Applications

From novice to tech pro — start learning today.