{"id":1886,"date":"2026-03-31T20:40:44","date_gmt":"2026-03-31T20:40:44","guid":{"rendered":"https:\/\/www.ultrexstaff.com\/?p=1886"},"modified":"2026-03-31T20:45:47","modified_gmt":"2026-03-31T20:45:47","slug":"sharepoint-excel-shortcut-guide","status":"publish","type":"post","link":"https:\/\/www.ultrexstaff.com\/?p=1886","title":{"rendered":"Sharepoint excel shortcut guide"},"content":{"rendered":"\n

If someone shared a SharePoint Excel file with you \u2014 through a link, a Teams message, or an email \u2014 you might find yourself navigating through your browser every time you need to open it. This guide shows you how to create a desktop shortcut that opens the file directly in the Excel desktop app, with full editing and co-authoring support.<\/p>\n\n\n\n

Before you start<\/h2>\n\n\n\n

Make sure you have:<\/p>\n\n\n\n

    \n
  1. Microsoft Excel installed on your computer (Microsoft 365 or Office 2016\/2019)<\/li>\n\n\n\n
  2. Access to the shared SharePoint file \u2014 you should already be able to open it in your browseR<\/li>\n<\/ol>\n\n\n\n

    This guide is for Windows. The shortcut approach works best when you have the Excel desktop app installed \u2014 not just Excel Online in the browser.<\/p>\n\n\n\n

    \n\n\n\n

    Step 1: Find your Excel installation path<\/h2>\n\n\n\n

    Before creating the shortcut, confirm where Excel is installed on your machine.<\/p>\n\n\n\n

    Locate EXCEL.EXE on your computer<\/p>\n\n\n\n

      \n
    1. Open File Explorer<\/strong>and navigate to:C:\\Program Files\\Microsoft Office\\root\\Office16\\<\/li>\n\n\n\n
    2. Look for EXCEL.EXE<\/strong>in that folder.<\/li>\n\n\n\n
    3. If it’s not there, try:C:\\Program Files (x86)\\Microsoft Office\\root\\Office16<\/li>\n<\/ol>\n\n\n\n

      Alternatively, search for Excel<\/strong> in the Start menu, right-click it, and choose Open file location<\/em> to find the exact path.<\/p>\n\n\n\n

      Step 2: Get the direct SharePoint file URL<\/h2>\n\n\n\n

      This is the most important step. You need the direct file path<\/em> \u2014 not a sharing link. Sharing links (which look like sharepoint.com\/:x:\/s\/…) don’t reliably open in Excel desktop and may open read-only.<\/p>\n\n\n\n

      Open the file and copy its direct path<\/p>\n\n\n\n

        \n
      1. Open the shared file in your browser using whatever link you were given.<\/li>\n\n\n\n
      2. In Excel Online, clickFile<\/strong>in the top-left corner.<\/li>\n\n\n\n
      3. At the bottom of the menu, click“Open in Desktop”<\/strong>to launch the file in the Excel desktop app.<\/li>\n\n\n\n
      4. Once open in Excel desktop, click File \u2192 Info<\/strong>.<\/li>\n\n\n\n
      5. You will see the SharePoint path listed at the top of the Info page. Click Copy Path<\/strong>.<\/li>\n<\/ol>\n\n\n\n

        The path should look something like this:<\/p>\n\n\n\n

        https:\/\/yourcompany.sharepoint.com\/sites\/YourSite\/Shared%20Documents\/Folder\/YourFile.xlsx<\/a><\/p>\n\n\n\n

        If the path ends with ?web=1<\/strong>, remove that part before using it in your shortcut. That parameter forces the file to open in the browser.<\/p>\n\n\n\n

        Step 3: Create the desktop shortcut<\/h2>\n\n\n\n

        Build the shortcut with the Excel path and file URL<\/p>\n\n\n\n

          \n
        1. Right-click an empty area of yourDesktop<\/strong>.<\/li>\n\n\n\n
        2. ChooseNew \u2192 Shortcut<\/strong>.<\/li>\n\n\n\n
        3. In the location field, enter the following \u2014 replacing the URL with the one you copied in Step 2:<\/li>\n<\/ol>\n\n\n\n

          “C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE” “https:\/\/yourcompany.sharepoint.com\/sites\/YourSite\/Shared%20Documents\/Folder\/YourFile.xlsx”<\/p>\n\n\n\n

            \n
          1. ClickNext<\/strong>, give the shortcut a friendly name (e.g.2026 Budget<\/em>), then clickFinish<\/strong>.<\/li>\n<\/ol>\n\n\n\n

            \"Create<\/p>\n\n\n\n

            The second screen of the Create Shortcut wizard \u2014 give it a clear name and click Finish.<\/p>\n\n\n\n

            Both the Excel path and the SharePoint URL must each be wrapped in their own set of quotation marks, with a space between them. Missing quotes are the most common cause of this not working.<\/p>\n\n\n\n

            Step 4: Test it<\/h2>\n\n\n\n

            Double-click your new shortcut. Excel should launch and open the file directly \u2014 no browser, no “Open in Desktop App” prompt. The file should open in edit mode with AutoSave enabled in the top-left corner.<\/p>\n\n\n\n

            If AutoSave is toggled on in the top-left of Excel, you’re in full co-authoring mode. Any colleagues who open the file at the same time will see your changes in real time.<\/p>\n\n\n\n

            \n\n\n\n

            Troubleshooting<\/h2>\n\n\n\n

            The file opens as read-only<\/h3>\n\n\n\n

            This usually means a sharing link was used instead of the direct file path. Go back to Step 2 and make sure you’re copying the path from File \u2192 Info<\/strong> inside the Excel desktop app \u2014 not from the browser address bar. If a yellow “Read-Only” banner appears, click Edit Workbook<\/strong> on that banner to unlock it for that session.<\/p>\n\n\n\n

            Excel can’t connect to the URL<\/h3>\n\n\n\n

            The URL copied from the browser address bar may contain ?web=1<\/strong> or be in a _layouts\/15\/Doc.aspx format \u2014 both are browser-only URLs that Excel cannot open directly. Use the path from File \u2192 Info<\/strong> inside Excel desktop instead.<\/p>\n\n\n\n

            The file opens in the browser instead of Excel<\/h3>\n\n\n\n

            Make sure both paths in the shortcut target are surrounded by their own quotation marks. A missing quote will cause Windows to misread the command and fall back to opening the URL in your default browser.<\/p>\n\n\n\n

            Excel isn’t at the Office16 path<\/h3>\n\n\n\n

            Press\u00a0Win\u00a0+\u00a0S<\/kbd>, type\u00a0Excel<\/strong>, right-click the result, and choose\u00a0Open file location<\/em>\u00a0to find the exact path to EXCEL.EXE on your machine.<\/p>\n\n\n\n

            \n\n\n\n

            Co-authoring: working on the file with others<\/h2>\n\n\n\n

            Once the file is stored on SharePoint and everyone opens it using the direct path (like the shortcut you just created), co-authoring happens automatically. You’ll see a colored cursor for each person editing simultaneously, and changes sync in real time \u2014 no manual saving needed.<\/p>\n\n\n\n

            For co-authoring to work smoothly, make sure:<\/p>\n\n\n\n

              \n
            1. Everyone opens the file from SharePoint \u2014 not from a locally downloaded copy saved to their PC.<\/li>\n\n\n\n
            2. AutoSave is turned on in the top-left corner of Excel.<\/li>\n\n\n\n
            3. Everyone has edit permission to the file in SharePoint, not just view access.<\/li>\n<\/ol>\n\n\n\n

              Quick recap<\/h2>\n\n\n\n
                \n
              • \u2713Find your Excel path \u2014 usually C:\\Program Files\\Microsoft Office\\root\\Office16\\EXCEL.EXE<\/strong><\/li>\n\n\n\n
              • \u2713Open the file in Excel desktop and copy the direct path from File \u2192 Info<\/li>\n\n\n\n
              • \u2713Remove?web=1from the end of the URL if present<\/li>\n\n\n\n
              • \u2713Create a new shortcut on your desktop with both paths in their own quotes<\/li>\n\n\n\n
              • \u2713Double-click to open \u2014 AutoSave on means co-authoring is live<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"

                If someone shared a SharePoint Excel file with you \u2014 through a link, a Teams message, or an email \u2014 you might find yourself navigating through your browser every time you need to open it. This guide shows you how to create a desktop shortcut that opens the file directly in the Excel desktop app, […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1886","post","type-post","status-publish","format-standard","hentry","category-uncategorized","post-preview"],"_links":{"self":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts\/1886","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1886"}],"version-history":[{"count":6,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts\/1886\/revisions"}],"predecessor-version":[{"id":1892,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=\/wp\/v2\/posts\/1886\/revisions\/1892"}],"wp:attachment":[{"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1886"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1886"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ultrexstaff.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1886"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}