Solved

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

Posted on 2014-01-21
2
371 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 33

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

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

There is no doubt that cloud is gaining importance. Many of you must have read about this technology and its growing importance. More and more organisations are embracing this technology not forgetting start-ups. The process begins by dipping …
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

807 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