Improve company productivity with a Business Account.Sign Up

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 378
  • Last Modified:

Sharing Workbooks

Is it really worthwhile sharing workbooks in Excel? Can we effectively share and work in the same workbook, in the same sheet at the same time, among five users?
Sanjay Gandhi
Sanjay Gandhi
2 Solutions
Rory ArchibaldCommented:
No. Shared Workbooks are notorious for becoming corrupt, losing data and exhibiting weird behaviour in addition to their functional limitations. They should be avoided at all costs.
(you will doubtless get about another 5 similar responses!)
Shared workbook tend to get corrupted! It's just a question of time until they get corrupted so you should avoid them as much as you can. It's better to create a workbook for each of your users to work and then link the important cells to one central workbook to get the information compiled.

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

It depends on the use.
If a small group of people works on it, and they only work in their own rows/columns it is fine.
I use it with my colleagues.

Make sure you use autoupdate feature.

but it will only be  a matter of time bfor you ask for help to ort out  corrupted shared file.

Sanjay GandhiFounder, KenhalAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now