To open a SharePoint Excel workbook in the desktop app, find it in the SharePoint document library, select Open and choose Open in app or Open in Desktop App. You can also open the workbook in Excel for the web first, then use its desktop-app option. You’ll need permission to access the file and Excel installed and signed in with an account that can open it.
What You’ll Need
- Access to the SharePoint site and workbook: Sign in with the work or school account that was granted access. If you can view but not edit the workbook, you may still be able to open it, but your changes could be read-only.
- Microsoft Excel for desktop: These instructions focus on Excel for Microsoft 365 on Windows. Excel may be installed through your organization or Microsoft 365 subscription. On a Mac, use the corresponding Excel app; the options are similar, though labels and prompts can differ.
- A supported, signed-in browser: Use a current browser and sign in to SharePoint. When the browser asks whether to open Microsoft Excel, allow it if you trust the site and expected the prompt.
- An internet connection: SharePoint must be reachable to locate and open the online workbook. You do not need to sync the whole document library to your computer.
Step-by-Step
- Sign in to the right Microsoft account. Open your organization’s SharePoint site in a browser and sign in with the account that has access to the workbook. If you use more than one Microsoft account, check the profile icon before continuing. A personal account may not have permission to open a work or school file, even if you are already signed in to Microsoft elsewhere.
- Find the workbook in its document library. Open the relevant SharePoint site, then go to the library or folder where the Excel file is stored. If you have a direct link, open it and confirm that the site and file name are the ones you expect. Use the library search if needed. Excel workbooks commonly end in
.xlsx,.xlsm, or another Excel file extension; do not assume a file is an Excel workbook just because its name looks familiar. - Open the file menu without changing the workbook. In the library, select the workbook’s row or use its three-dot menu. Look for Open, then choose Open in app or Open in Desktop App, depending on the SharePoint layout. In some layouts, the Open command appears on the toolbar after you select a file. If selecting the file name opens a browser preview or Excel for the web instead, continue to the next step.
- Choose the desktop option from the browser view. If the workbook has opened in Excel for the web, look near the top of the page for an option such as Open in Desktop App or Open in app. The exact placement and wording can vary with the current SharePoint and Excel interface. Choose the option that explicitly opens the desktop app, not a command that just switches to another browser view. If the option is missing, see Troubleshooting below.
- Allow the browser to launch Excel. Your browser may show a confirmation asking whether to open Microsoft Excel or another Microsoft 365 application. Confirm the launch if the request came from your organization’s SharePoint site and you intended to open the workbook. Depending on your browser settings, you may be able to remember the choice for that site. Do not approve an unexpected prompt from an unfamiliar page.
- Wait for the workbook to finish loading. Excel may take a moment to start, contact SharePoint, and download workbook content. If a sign-in window appears, use the same work or school account that has SharePoint access. Keep the browser window open until Excel has launched and the workbook is visible; closing it too early can interrupt the handoff on some setups.
- Check the workbook’s access and save status. Look at the title bar and the status area in Excel. Confirm that the expected file is open and that you can edit it if editing is your goal. If Excel says Read Only, or displays a permission message, you can usually view the file but need edit permission to make changes. When AutoSave is available, check that it is on and that Excel reports the latest changes are saved. If AutoSave is off or the workbook is not connected, resolve that before assuming your edits have reached SharePoint.
- Make a small, safe confirmation if appropriate. If you have edit access, make a minor change only when it is appropriate for the workbook, then wait for Excel to show that it is saved. For a shared or important workbook, do not add test text just to check the connection; instead, review the save status or ask the file owner to confirm your access. When finished, close the workbook normally so Excel can complete any pending save.
Common Mistakes
- Opening the wrong copy: A workbook downloaded earlier or saved in a local folder may have the same name as the SharePoint file. Check the file name and SharePoint location in Excel before editing. If you edit a local copy, those changes do not automatically update the original library file.
- Choosing the browser version by accident: Selecting the file name often opens Excel for the web, which is useful but is not the desktop app. Use the explicit desktop-app command from the library or the web workbook.
- Signing in with a different account: Having Excel installed is not enough if it is signed in with an account that lacks access. Match the account in Excel to the account you used in SharePoint.
- Assuming view access means edit access: A successful open does not guarantee permission to change or save the workbook. Check whether Excel shows Read Only or a view-only status before making edits.
- Ignoring a launch confirmation: If the browser is waiting for permission to open Excel, the workbook may remain in the browser until you respond. Approve the prompt only when it is expected and comes from the site you intended to use.
- Closing before a save completes: Do not close Excel or disconnect from the network while a save is pending. Wait for the saved status, especially after making a large change or working in a workbook with other collaborators.
Tips
- Use the library as your source of truth. Starting from the SharePoint library or a current SharePoint link reduces the chance of editing an old downloaded copy. If you received a link in email or chat, check that it points to the organization’s site and the correct workbook.
- Keep co-authoring in mind. Other people may be editing the same workbook. Excel for Microsoft 365 can support co-authoring for compatible files and setups, but collaboration depends on account access, file format, and organizational settings. Look for collaborator indicators and avoid making conflicting changes to the same cells.
- Use Excel for the web when it is the practical choice. The browser version can be convenient when you do not have the desktop app available. If you need a desktop feature, use the desktop option when offered; not every feature works identically in Excel for the web.
- Do not sync the library unless you need offline access. OneDrive syncing can make library files available through File Explorer, but it is not required just to open a workbook in desktop Excel. If you do use a synced folder, confirm that OneDrive has finished syncing before relying on the local copy elsewhere.
- Take care with macro-enabled files. A workbook ending in
.xlsmcan contain macros. Excel may show a security warning, and your organization may restrict macros. Only enable content when you trust the file and your organization’s rules allow it; opening the file in the desktop app does not itself mean macros should be enabled. - Know the Mac difference. On macOS, use the same SharePoint or Excel-for-the-web desktop-app option to hand off the workbook to Excel for Mac. The browser confirmation and sign-in flow may look different from Windows. If Excel for Mac is not installed or not signed in, install or sign in to the authorized app before retrying.
Troubleshooting
The workbook stays in the browser. Return to the file menu in the library or the open workbook and look again for Open in app or Open in Desktop App. If the command is not available, the organization may have disabled desktop opening, the file type may not be supported for that route, or you may not have the required access. Try another current browser if your organization permits it, and ask the site owner or IT team whether desktop opening is allowed.
Nothing happens after you choose the desktop option. Check whether the browser displayed a pop-up or external-app confirmation that is waiting for a response. Allow the handoff for the trusted SharePoint site. Then check whether Excel is already open behind other windows or still starting. If Excel does not launch, close the stalled browser prompt, reopen the workbook from SharePoint, and try again. A browser setting, security product, or organization policy may block app links; your IT team can confirm the permitted setup.
Excel opens but asks for a password or sign-in. First confirm you are using the correct work or school account. If the workbook is protected with a file password, SharePoint permission alone will not remove that protection; ask the owner for the password or an authorized copy. If sign-in repeatedly loops, sign out of the extra Microsoft account in Excel or the browser, then sign in with the account that has access. Avoid sending a password through an insecure channel.
You can open the file but cannot edit it. Check for a Read Only message or a view-only banner. Ask the owner to grant edit permission or to share the file with the correct account. Also check whether the workbook is locked for editing, checked out, or restricted by an organizational policy. Do not save a separate copy over the original unless the owner has asked you to do so; that can create competing versions.
Excel reports a sync or save problem. Keep the workbook open and check your internet connection and the account shown in Excel. If the file is in a synced OneDrive folder, check the OneDrive sync status as well. Follow any prompts to reconnect or resolve a conflict, and verify the saved status before closing. If Excel offers a conflicting copy, compare the versions carefully or ask the site owner for help rather than overwriting work you cannot identify.
The workbook opens with a warning or unusual formatting. Excel may flag an older or restricted file format, external links, protected content, or macros. Read the warning and follow your organization’s security policy. If the workbook is essential and appears damaged, stop editing it and contact the owner. The owner can check the original in SharePoint or provide a known-good copy.
Frequently Asked Questions
Can I open a SharePoint Excel file in the desktop app without downloading it?
Yes. Use the library’s desktop-app command or the equivalent option in Excel for the web. Excel opens the SharePoint workbook directly, so you do not have to manually download and re-upload a copy.
Why does my SharePoint file open in Excel for the web instead?
Clicking the file name commonly opens the browser version. Choose Open in app or Open in Desktop App from the file menu or workbook page. If that command is unavailable, your organization’s settings, permissions, browser, or the file type may prevent the handoff.
Do I need to install OneDrive to use the desktop app?
No. You can open a workbook from SharePoint in desktop Excel without syncing the library to File Explorer. OneDrive syncing is a separate option that can help when you need local or offline access, but it is not a requirement for opening the online file.
Will edits in desktop Excel save back to SharePoint?
When you open the SharePoint-hosted workbook directly and have edit permission, Excel can save changes to that online file. Check the save or AutoSave status before closing. If you opened a downloaded copy instead, its changes may not be reflected in SharePoint.
Can I open the workbook on a Mac?
Yes, if Excel for Mac is installed and you can access the SharePoint file. Use the desktop-app option from SharePoint or Excel for the web. The browser prompt and some interface labels can differ from Windows, and your organization may restrict which apps can open its files.
What if I only have permission to view the workbook?
You can generally open and read it, but Excel may mark it Read Only or prevent changes from being saved. Ask the file owner for edit access if you need to make changes. Avoid downloading a separate copy and treating it as the shared original.
Related
- How to Lock an Excel Cell or Range and Protect the Sheet
- Lock an Excel Cell from Being Edited: Step-by-Step
- Keep a Zero in Front of a Number in Excel: Simple Fixes
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Day Number: Serial Dates, Day of Month and YearIf A2 contains a valid Excel date such as June 15, 2024, and you want its day of…
- Nested IFs in Google Sheets: Formulas and AlternativesTo create nested IFs in Google Sheets, put another IF inside the first one’s result: for example, with…
- How to Add and Edit Footnotes in Word, Step by StepTo add a footnote in Microsoft Word, click where its reference number should appear, then choose References >…
- Unhide Columns in Excel Using the KeyboardIn Excel for Microsoft 365 on Windows, select the columns on both sides of the hidden area, then…
- Excel Data Validation List from a Table: How to Set It UpYes. In Excel for Microsoft 365 on Windows, turn a table column into a drop-down list by creating…
- Google Sheets IFS: Syntax, Examples, and FixesIn Google Sheets, IFS checks conditions in order and returns the result for the first condition that is…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.