Solved

Shared xlsx workbook

Posted on 2013-11-20
12
428 Views
Last Modified: 2013-11-21
We have a large MS excel workbook - we need to have several people in it at the same time, editing different worksheets.   What solutions are available for this multiple edits problem?

thanks

bp
0
Comment
Question by:brianpowell
12 Comments
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39662572
Do the sheets depend on each other in any way?
0
 
LVL 6

Accepted Solution

by:
Michael earned 50 total points
ID: 39662959
Have you considered Google Docs? It supports real-time collaboration.

You and others with access to the file can make edits to that file at the same time. You’ll be able to see what others are up to keystroke by keystroke, and they’ll be able to see what changes you’re making as you make them
0
 
LVL 43

Assisted Solution

by:Saqib Husain, Syed
Saqib Husain, Syed earned 200 total points
ID: 39664968
A general opinion of excel experts is that using excel files in shared mode is a big NO NO. They are highly prone to corruption.

JazzyJoop's suggestion is good if the file size is not large. If you are within the limits given on this page from Google then you are good to go.

Another point of concern could be security. Once the thing is on the net then it is susceptible to hacking,

Another alternative could be Access which you will have to take up in another topic area.
0
 
LVL 1

Author Comment

by:brianpowell
ID: 39665760
Sorry for the delay... craziness. Will review.
0
 
LVL 1

Author Comment

by:brianpowell
ID: 39665765
SIZE: 21.3 MB (22,374,010 bytes)

FILE TYPE: *.xlsm
0
 
LVL 1

Author Comment

by:brianpowell
ID: 39665769
Do the sheets depend on each other in any way?

Presumption is yes Pivot tables and such for charting. (lots of charts!)
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 1

Author Comment

by:brianpowell
ID: 39665778
Google docs I like:   but this is an excel workbook that is unmanaged and very hairy.
0
 
LVL 1

Author Comment

by:brianpowell
ID: 39665781
Security is not an issue or can be categorized as very low.
0
 
LVL 1

Author Comment

by:brianpowell
ID: 39665786
A general opinion of excel experts is that using excel files in shared mode is a big NO NO. They are highly prone to corruption.

Could you post  the source, for the above comment e.g. provide a source (s)?

thanks

bp
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39665840
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39665854
0
 
LVL 1

Author Closing Comment

by:brianpowell
ID: 39666833
thanks!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The new Microsoft OS looks great, is easier than ever to upgrade to, it is even free.  So what's the catch?  If you don't change the privacy settings, Microsoft will, in accordance with the (EULA) you clicked okay to without reading, collect all the…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

862 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

24 Experts available now in Live!

Get 1:1 Help Now