Solved

Shared xlsx workbook

Posted on 2013-11-20
12
457 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
Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

 
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
 
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

As with any other System Center product, the installation for the Authoring Tool can be quite a pain sometimes. This article serves to help you avoid making these mistakes and hopefully save you a ton of time on troubleshooting :)  Step 1: Make sur…
User Beware!  This is a rather permanent solution to removing your email from an exchange server.  The only way to truly go back is to have your exchange administrator restore your mailbox from backups.  This is usually the option of last resort.  A…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

825 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