• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 126
  • Last Modified:

Can I Coauthor an Excel xlsx file on Google Drive or does it need to be on OneDrive?

I have an Excel spreadsheet that I need to share with a few other users. I have saved it on Google Drive and we all have access to it but I am worried about what might happen if two of us try to open the same spreadsheet at the same time and make changes. I know Google Sheets can handle that well but will it work reliably in Drive?

What tips do you have? What should I look out for?
0
Rob4077
Asked:
Rob4077
  • 2
  • 2
  • 2
2 Solutions
 
Rob4077Author Commented:
Thanks Zeth.

That video says "the document needs to be stored in the cloud... like One Drive". When I click on the Share link on my spreadsheet, the only option it brings up is OneDrive. However other web pages I've searched say that you can share files using Google Drive too. What I am trying to work out is if you can coauthor using Google Drive, or just share using Google Drive.  

My understanding is that sharing means multiple users can edit and save the file but there are potential sync conflics, whereas coauthoring means multiple users can work on the same file concurrently and syncing is done in real time. Maybe my understanding is wrong
0
 
Zeth LarssonCommented:
I'm sure you are right about share and co-authoring. And co-authoring is what he is talking about in the video, event if he click on "share" to start it :-)
But may be "cloud... like One Drive" is to be so very much like, so it is exactly:-)
I have only tryed MS Excel share feature my self.

Hope you solve it to you needs.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Roy CoxGroup Finance ManagerCommented:
If two users access and work on an Excel sheet in Google Drive at the same time then a "conflcted" version will be created.

Excel is not really good for multi-users, but MS have introduce a feature called Collaboration, see this, it requires One Drive though.
0
 
Rob4077Author Commented:
Thanks for the confirmation. I wish I could use Google Sheets for what I am doing but that means learning their language and I don't have time. I will try moving my spreadsheet to OneDrive to see how it works but last time I tried using OneDrive it was very, very flaky and I kept losing data and having to reload things.
0
 
Roy CoxGroup Finance ManagerCommented:
I use Google Drive for storage and working with Excel, but not multi users. I have no issues with One Drive at all.

Glad I helped.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now