A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Open the workbook from Excel itself by connecting your personal OneDrive account, rather than opening its onedrive.live.com browser URL.
Open the OneDrive file in desktop Excel
- Start the Excel desktop app.
- Select File → Account.
- Select Add a service → Storage → OneDrive.
- Sign in with the same personal Microsoft account used on OneDrive.
- Return to File → Open and select OneDrive – Personal.
- Browse to the workbook and open it.
Excel should now open the actual workbook in the desktop application while keeping it stored in OneDrive. ^1^
The address beginning with https://onedrive.live.com/... is a browser link, not a local Excel filename. Microsoft notes that links opened from a browser continue opening in the Microsoft 365 web apps; the File open preference setting applies to links clicked from supported Microsoft 365 desktop applications, not links opened on a website. ^2^
Alternative: open the synchronized file
If your OneDrive files appear in Windows File Explorer:
- Select Start, search for OneDrive, and open the OneDrive desktop app.
- Open File Explorer → OneDrive – Personal.
- Find the
.xlsxfile and double-click it. - If Windows asks which application to use, select Excel.
Starting OneDrive is also Microsoft’s documented action when Windows reports that it cannot open a file or that OneDrive is not running. ^3^
About “Open in app”
Since Open in app is no longer completing the handoff, use either method above instead of repeatedly selecting it. Microsoft’s published OneDrive → More → Open → Open in app procedure specifically describes work or school accounts and requires the OneDrive sync client plus Files On-Demand; it does not establish the same applicability for the personal onedrive.live.com page shown here. ^4^
References