Solved

Sharing an excel sheet...with googledocs? Possible?

Posted on 2014-01-21
2
368 Views
Last Modified: 2014-01-28
hi guys,

A few of us are trying to work on one Excel sheet and update it simultaneously. Is that possible using Googledocs? If yes, how do you do it?

Thanks
Yashy
0
Comment
Question by:Yashy
2 Comments
 
LVL 4

Accepted Solution

by:
tmx84 earned 300 total points
ID: 39798465
You would have to do it within googledocs.  Here is a link on collaboration and how to share the file...  https://support.google.com/drive/answer/2494891?hl=en

So you wouldn't be working directly in excel, you would need to do it through the web/googledocs if that makes sense..
0
 
LVL 32

Assisted Solution

by:Rob Henson
Rob Henson earned 200 total points
ID: 39799407
If the file is stored on a shared drive there is the option within Excel to make it a Shared Workbook whereby multiple people have Write Access at the same time.

HOWEVER, eventhough I have told you about this feature I would not recommend using it as it is consistently unreliable and can create more problems than it is worth. A simple search on EE for Shared Workbooks will show nuymerous threads where people have used this feature and come across problems. There are however a few, and they are in the small minority, where they have succeeded with the feature.

Thanks
Rob H
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Finding a closest match in Excel 7 47
Make a Cell act like a Date 7 39
Move data from one sheet to another 11 36
Excel format formula for currency 15 24
Big data transfers via information superhighways require special attention and protection. Learn more about the IT-regulations of the country where your server is located. Analyze cloud providers and their encryption systems for safe data transit. S…
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.
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 how to use longer labels with horizontal bar charts instead of the vertical column chart.

778 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