Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Shared xlsx workbook

Posted on 2013-11-20
12
Medium Priority
?
528 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
12 Comments
 
LVL 49

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 150 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 600 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
Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

 
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: 39665854
0
 
LVL 1

Author Closing Comment

by:brianpowell
ID: 39666833
thanks!
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

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

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

730 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