Hello -
I saw the below inquiry posted in 2020 but no responses were posted to it. I am having the same issue, exactly as outlined below. My husband is able to open the desktop app on his computer and I am not able to on mine. The shared files have both our microsoft accounts listed with full access. I've been searching the web for solutions but no luck yet. Any help would be appreciated. I have the same issue with both Word documents and Excel files.
I have edit permissions to a set of files that someone shared with me through OneDrive. I access the files through a browser and can edit them through Office apps online. However, there are some features of Excel, for example, that you can't use in Excel online so I open the file using the "Open in Desktop App" function. This all worked seamlessly on my old PC but I recently purchased a new PC.
Now I can still open the Excel file using Excel online but when I try to "Open in Desktop App", I am prompted for my Microsoft Account. I type in my email address and click Next, the dialog box flashes, and returns to asking me for my email address. I never get a prompt for my password. On the old PC I didn't have the prompt for my Microsoft Account.
At the time I'm accessing the shared file in OneDrive and when I edit it online I am logged into my Microsoft Account. Why is prompting me for my account again with I try to go to the desktop Excel? If it does need the account again, why don't I get a prompt for the password?
I'm on a current version of Windows 10 and have current version of Office for Home.
Some additional information: my husband has his own log in on the same computer and his own Microsoft account with access to edit the same shared files. He can log in to the PC, access the shared Excel files and can use the desktop app without getting a prompt to log in to a Microsoft account. Is this some how related to the credentials? I was the first to create an account on the machine.