Applies ToExcel for Microsoft 365 Word for Microsoft 365 PowerPoint for Microsoft 365 Access for Microsoft 365 Publisher for Microsoft 365 Visio Plan 2 Excel 2024 Word 2024 PowerPoint 2024 Access 2024 Project Professional 2024 Visio Professional 2024 Excel 2021 Word 2021 PowerPoint 2021 Access 2021 Project Professional 2021 Publisher 2021 Visio Professional 2021 Excel 2019 Word 2019 PowerPoint 2019 Access 2019 Project Professional 2019 Publisher 2019 Visio Professional 2019 Excel 2016 Word 2016 PowerPoint 2016 Access 2016 Project Professional 2016 Publisher 2016 Visio Professional 2016 Visio Professional 2013

You can open or check out a file from a SharePoint library from within your Microsoft 365 app.

After you open a file from the library, Word, Excel, and PowerPoint also keep a link to that SharePoint location on the File tab under Recent Places.

Open an Office file

  1. In your app, select File > Open.

  2. On the left, under the Open heading, select the  The SharePoint icon.  entry in the list.

    A scrollable list of SharePoint document libraries that you're connected to appears. 

  3. Select the document library that contains the file you want to open.

  4. Select the file you want to open.

    You're ready to edit the file.

  5. (Optional) If the document library requires that the file be checked out in order to edit it, a yellow bar appears near the top of the window indicating that check-out is necessary. Just select Check Out to proceed:

    The yellow bar has a button to make it easy to check out the file for editing.

Check out an open file for exclusive editing

By default, when you open a file from a SharePoint document library, it is a co-authoring situation. Other people may open the file at the same time as you to contribute to it. That is fine in many cases, but at times it may be best to check out the file so only you can edit it. 

When you check out a file, you are the only person who can change it. This reduces the potential for confusion and conflicting edits.

After you make changes to a file, you must check in the file so that other people can see your changes when they open the file.

  1. With the file open in the app, select File > Info.

  2. Select Manage ... > Check Out

    If the Check Out option is grayed out, it means that someone else currently has the file open for editing. You can co-author with them, but you can't check out the file for exclusive editing while someone else has the file open.

Learn More

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.