Solved

Sharing Workbooks

Posted on 2011-03-17
6
319 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:sanjay-gandhi
6 Comments
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 63 total points
Comment Utility
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!)
0
 
LVL 33

Assisted Solution

by:jppinto
jppinto earned 62 total points
Comment Utility
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.

jppinto
0
 
LVL 33

Expert Comment

by:jppinto
Comment Utility
:)
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 6

Expert Comment

by:nagyistvan
Comment Utility
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.
0
 
LVL 45

Expert Comment

by:patrickab
Comment Utility
Sorry,

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

Patrick
0
 

Author Closing Comment

by:sanjay-gandhi
Comment Utility
Thanks.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now