April 9, 2024
Contribute to the Microsoft 365 and Office forum!
Click here to learn more 💡
May 10, 2024
Word Forum Top Contributors:
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?)
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?
Report abuse
Thank you.
Reported content has been submitted
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:
http://blogs.office.com/b/microsoft-word/archive/tags/co_2D00_authoring/
http://www.informationweek.com/news/smb/hardware_software/226400004 (Tells how to make co-authoring work, conversely, how to ‘break’ it!)
http://blogs.office.com/b/microsoft-word/archive/2011/03/25/4-ways-to-work-together-in-word.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".
http://blogs.office.com/b/microsoft-word/archive/2009/09/09/co-authoring-in-word-2010.aspx
http://channel9.msdn.com/Blogs/coolstuff/Co-Authoring-Using-Office-2010
http://technet.microsoft.com/en-us/library/ff718249.aspx#bkmk_ca_in_sp
http://www.cio.com/article/497092/Microsoft_Office_2010_Three_Helpful_New_Collaboration_Features_
https://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HP010096833.aspx
*****
.
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
Report abuse
Thank you.
Reported content has been submitted
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
Report abuse
Thank you.
Reported content has been submitted
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: