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?
LVL 1
Rob4077Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook 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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.