To open a SharePoint workbook in the desktop Excel app, find the file in its SharePoint document library, select it, and choose Open > Open in app (or the similarly named command). Approve your browser’s prompt to launch Excel. You’ll need access to the SharePoint file and the desktop version of Excel installed; opening it this way keeps the workbook connected to its SharePoint location.
What You’ll Need
- Access to the SharePoint site and workbook. Sign in with the work or school account that has permission to open the file. You may need edit permission to make and save changes.
- The Excel desktop app. These instructions are for Microsoft 365 on Windows. Excel for Mac can also open a workbook from SharePoint; the browser handoff and prompts can look different.
- A supported browser and a working internet connection. Your browser must be able to hand the file off to Excel. You do not need to sync the library with OneDrive first.
Step-by-Step
- Sign in to SharePoint. Open your organization’s SharePoint site in a browser and sign in with the account that has access to the workbook. If you have more than one Microsoft account, check the account shown in the page or profile menu before continuing. Using a personal account instead of your work account is a common reason a file is missing or access is denied.
- Go to the document library. Open the site that contains the workbook, then select the relevant library, often named Documents or Shared Documents. If you have a link to a folder or file, you can use it, provided it takes you to the organization’s SharePoint site. Browse to the folder containing the workbook rather than opening a similarly named file elsewhere.
- Find and select the workbook. Look for the Excel file, usually ending in .xlsx, .xlsm, or .xls. Click the file’s row or selection circle once so it is selected. Avoid double-clicking if your goal is to choose a specific app; a double-click normally opens the file using the library’s default behavior, which may be Excel for the web.
- Open the app menu. In the library’s command bar, select Open, then choose Open in app or Open in Excel, depending on the version of SharePoint and the labels your organization displays. If you have already opened the workbook in a browser preview, look for an Open menu or an Open in app command at the top of the page. The wording and location may vary slightly, but choose the option that explicitly opens the desktop app, not Open in browser.
- Approve the browser handoff. Your browser may show a message asking whether to open Microsoft Excel. Choose Open or Open Microsoft Excel. If there is an option to always allow this site to open links in the associated app, use it only if this is a trusted work or school SharePoint site and you want to avoid the prompt next time. If the browser displays a security warning, check the site address before approving it.
- Wait for Excel to load and check the account. Excel may take a short time to start, contact SharePoint, and load the workbook. If Excel asks you to sign in, use the same work or school account that you used for SharePoint. If an editing banner appears, read it before making changes; the workbook might be read-only, checked out by another user, or opened in Protected View. When it is available, select Enable Editing only if you trust the file and expected to edit it.
- Confirm you are working on the SharePoint copy. Check the workbook name in Excel and look at the save or status information near the top of the window. A file opened directly from SharePoint should remain associated with its online location; you should not need to save a separate download to your computer. Make a small, appropriate change only if you have permission, then wait for Excel to indicate that the change has been saved. Avoid closing the workbook while it is still saving.
On a Mac: Use the same SharePoint command to open the workbook in the app, then approve the browser prompt to launch Excel for Mac. If you are already viewing the file in Excel for the web, use its available Open in Desktop App command. The exact prompt depends on your browser and macOS settings. Once Excel opens, sign in with the account that has access to the SharePoint file.
Common Mistakes
- Choosing the wrong open option. Open in browser opens Excel for the web; it does not launch the desktop program. Return to the library or the workbook’s open menu and choose the app option.
- Downloading the workbook instead. A download creates a local copy. Changes to that copy do not automatically update the SharePoint file, and you could end up editing a stale version. Use the app-opening command when you want to work with the shared file.
- Using an account without access. Having Excel installed does not grant permission to a SharePoint library. Make sure Excel and the browser are signed in with the authorized work or school account.
- Assuming every workbook can be edited. A file may be read-only, checked out, protected, or restricted by its owner. Opening it in the app changes where it is displayed, not the permissions applied to it.
- Closing Excel before the save finishes. Wait for the save status to confirm that changes are synchronized. A brief delay can happen when the connection is slow or several people are editing.
Tips
- Use the SharePoint library as your starting point. It makes it easier to identify the shared source file and select the correct app-opening command. If a coworker sent a link, confirm that it points to the expected site and workbook.
- Check the file type before opening. Standard Excel formats such as .xlsx and .xlsm are typically opened by Excel, but an organization’s policies or file settings can affect what happens. A file with a different extension may not be an Excel workbook even if its name looks familiar.
- Let Excel finish syncing. With a reliable connection, changes to a SharePoint workbook can save online while you work. Look for the save status before switching off your connection or closing the file. If Excel reports a problem, resolve it rather than assuming the latest changes reached SharePoint.
- Coordinate on heavily shared workbooks. Microsoft 365 supports coauthoring for compatible files and setups, but restrictions, older formats, or certain workbook features can affect collaboration. If you see a message that another person has locked the file, follow the message or ask the file owner before creating another copy.
- Use OneDrive sync only if it suits your workflow. Syncing a SharePoint library can make its files available through File Explorer, but it is optional for opening a workbook in Excel. If your organization already uses sync, open the file from the synced library and check that OneDrive is connected before relying on it for updates.
Troubleshooting
- The Open in app option is missing. Confirm that you selected a workbook rather than a folder, and check the command bar’s Open menu or the workbook preview. If the command is still absent, your organization’s SharePoint settings, permissions, or file type may limit available actions. Ask the site owner or Microsoft 365 administrator whether opening documents in desktop apps is allowed.
- The browser does nothing after you choose the app. Look for a blocked pop-up or external-app prompt near the browser’s address bar or downloads area. Approve the prompt for the trusted SharePoint site. If there is no prompt, check that Excel is installed and can start, then retry in a supported, up-to-date browser. You can also sign out and back in to refresh the browser session.
- Excel opens, but asks for a password or another sign-in. First verify that the workbook requires your work or school account rather than a personal Microsoft account. Sign in with the account authorized for the site. If Excel keeps asking, close any extra Office accounts that are not needed, restart Excel, and try again. Do not share a password or bypass an organization’s sign-in requirements.
- The file opens read-only or says it is locked. Check whether you have edit permission, whether the file is checked out, and whether another person or process has it locked. Contact the owner or library administrator if you need editing access. If you only need to review it, you can continue in read-only mode; do not make a separate copy and assume it will update the shared original.
- Changes are not appearing in SharePoint. In Excel, check for a save error, a disconnected status, or a sign-in request. Reconnect to the internet and resolve any account prompt, then wait for Excel to finish saving. If the workbook was downloaded or opened from a local folder, it is a separate copy; compare it carefully with the SharePoint file before moving or copying changes. If a conflict warning appears, follow its choices and ask the owner for help if you are unsure which version to keep.
- The workbook keeps opening in Excel for the web. Return to the library and select the desktop-app command rather than opening the file normally. If your library is configured to open documents in a browser by default, the explicit app command may still be available. If it is not, ask the site owner or administrator whether the library’s document-opening setting can be changed; you may not have permission to change that setting yourself.
Frequently Asked Questions
Can I open a SharePoint workbook in Excel without syncing the library?
Yes. Browse to the workbook in SharePoint and choose Open > Open in app. OneDrive library sync is optional and is not required for the direct app-opening method.
Will changes in the Excel app save back to SharePoint?
They should save to the shared workbook when you opened it directly from SharePoint, have permission to edit, and Excel is connected. Check Excel’s save status before closing. A downloaded or separately saved copy is not the same shared file.
Can I use this method with Excel for the web?
The method is specifically for opening the desktop Excel app. If you choose Open in browser, the workbook stays in Excel for the web. The web version is useful when the desktop app is unavailable or you only need browser-based access.
Why does Excel ask me to sign in when SharePoint is already open?
The browser and desktop app can have separate sign-in sessions, or they may be using different accounts. Sign in to Excel with the work or school account that has permission to the SharePoint library.
Can I open a SharePoint workbook in Excel for Mac?
Yes, if Excel for Mac is installed and your organization permits opening files in desktop apps. Choose the app option in SharePoint and approve the browser’s prompt. Menus and prompts can differ from Windows, but the workbook still needs the right SharePoint permissions.
Is opening in the app the same as downloading the file?
No. Opening in the app connects Excel to the SharePoint workbook, while downloading creates a separate local copy. Choose the app option when you want to work with the shared file and its online save behavior.
Related
- Excel Share Mode: How to Keep Your Workbook Shared
- Excel Insert Row Shortcut: Steps for Windows and Mac
- How to Insert Multiple Images in an Excel Cell: Guide
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Google Sheets Timesheet Template: Free Setup and TipsYes. You can use a free timesheet template in Google Sheets by opening a suitable template from the…
- How to Copy an Entire Sheet in Excel: Steps and TipsTo copy an entire worksheet in Excel for Microsoft 365 on Windows, right-click its sheet tab, choose Move…
- Freeze 2 Panes in Excel: What Works and What Doesn’tTo freeze two parts of a worksheet at once in Excel, select the cell just below the rows…
- Find Excel Spreadsheet Not Saved? Recovery Steps That WorkIf you closed an Excel workbook without saving, open Excel and select File > Info > Manage Workbook…
- Add a Header in Excel for the WebTo add column headings in Excel for the web, type a label into the top cell of each…
- How to Archive Email in the Outlook App on Any DeviceTo archive an email in Outlook, select the message and choose Archive (usually the box-shaped icon). Outlook removes…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.