How to edit Word or Excel 2013 files on 2 computers at the same time? (It looks like OneNote & PowerPoint can do it all the time but not Word or Excel?)

Hi guys,

I have a PC and a tablet. I also have both the SkyDrive Desktop app installed, so I can pull the documents and edit them whenever from various places.

When I try to open the same file in OneNote (i.e., a NoteBook) or the same PowerPoint presentation, it allows for both computers to simultaneously edit the document (great for annotating on one and typing on the other). This occurs without any problems as long as the files are in the new format. I've noticed if the PowerPoints are in the older format (2007-2010, then it will not work.

The main problem is with Word and Excel 2013. I have noticed this simultaneous editing does not always work for Word. It never seems to work at all for Excel. I've noticed certain documents will allow me to edit them while others will not (any reasons?) When it does not give access, there will be an error saying "File In Use. This file is locked for editing by another user." Some Word 2013 files work and some files do not. I've checked the files that works and the files that do not, but they're both free of any type of restrictions. Anyone know why I am unable to open and edit some of these files on more than one computer?
I don't have a specific answer to your question. I know it is possible, I just don' know about this problem.  The only guess I could make is that maybe the problem files were not created in 2010 or 2013 ...?

One thing you want to do is go into File tab > Options command > General option. Make sure the "User Name" is filled in.  In older versions of Office it is used to populate the "this file for editing by another user".  If there is a unique name in it, you knew who to talk to, but too often in corporate settings the name was not filled in so everyone generated the same message.

Here are a couple of brief blogs with simple instructions, maybe one will highlight something you are doing "wrong". They both link to the same video (grin).
search for coauthoring blogs:
MS Word Blog – Co-authoring tag search

http://blogs.office.com/b/microsoft-word/archive/tags/co_2D00_authoring/



Office 2010 Collaboration / co-authoring User's Guide

http://www.informationweek.com/news/smb/hardware_software/226400004  (Tells how to make co-authoring work, conversely, how to ‘break’ it!)

 



Easy to do Co-Authoring using SharePoint video (or Skydrive)

http://blogs.office.com/b/microsoft-word/archive/2011/03/25/4-ways-to-work-together-in-word.aspx

 

Coauthor your way to a single document version (Skydrive text instructions)

http://blogs.office.com/b/microsoft-word/archive/2011/01/11/eliminate-multiple-document-versions-with-coauthoring.aspx


Here is a bunch more information I've collected on the subject. Most of it is repetitive, but every now and then you find a useful "gem".


 

MS Office 365 and MS Office 2010: Better together – Co-Authoring

http://www.techrepublic.com/blog/msoffice/microsoft-office-365-and-microsoft-office-2010-better-together/7626

 


Co-authoring (i.e. Simultaneous Editing) in Word 2010

http://blogs.office.com/b/microsoft-word/archive/2009/09/09/co-authoring-in-word-2010.aspx

 


 

Co-author Word docs on PC, Mac AND the browser In Office 2010 using Office Web Apps or Sharepoint

http://channel9.msdn.com/Blogs/coolstuff/Co-Authoring-Using-Office-2010

http://blogs.office.com/b/office_blog/archive/2011/07/12/co-author-word-docs-on-pc-mac-and-the-browser.aspx

http://office.microsoft.com/en-us/web-apps-help/work-together-on-a-document-in-word-web-app-HA102506009.aspx

http://blogs.office.com/b/microsoft-word/archive/2011/10/05/coauthoring-feature-in-microsoft-word.aspx

https://blogs.msdn.com/b/mvpawardprogram/archive/2010/12/20/mvps-for-office-and-sharepoint-2010-work-without-the-wait.aspx

http://technet.microsoft.com/en-us/library/ff718249.aspx#bkmk_ca_in_sp

 

SharePoint Server 2010 MSDN Online Training Labs Plus other resources

https://blogs.msdn.com/b/mssmallbiz/archive/2012/03/13/sharepoint-server-2010-msdn-virtual-labs-available-to-you-online-plus-more-sharepoint-2010-resources.aspx?Redirected=true

 

Office 2010: Three Helpful New Collaboration / Co-Authoring Features

http://www.cio.com/article/497092/Microsoft_Office_2010_Three_Helpful_New_Collaboration_Features_

 

Use a shared 2007 workbook to collaborate

https://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HP010096833.aspx

 

Collaborative editing using the Excel 2010 Web App

http://blogs.office.com/b/microsoft-excel/archive/2010/01/21/collaborative-editing-using-excel-web-app.aspx

 

New features of Microsoft Office 2010 focus on collaboration, integration

http://www.theglobeandmail.com/news/technology/microsoft-office-2010-review-new-features-of-microsoft-office-2010-focus-on-collaboration-integration/article1589587/



.
*****
.
As computer scientists we are trained to communicate with the dumbest things in the world – computers –
so you’d think we’d be able to communicate quite well with people.
Prof. Doug Fisher

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Not sure about Word, but you need to save Excel files as shared.  Check out File, Info, Prepare for Sharing.

 

Edit to Add:   Same tab is available in Word.

--
The more people I meet, the more I like my dog.
MCC 2011, 2015, 2017

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated October 27, 2022 Views 9,051 Applies to: