Search code examples
ms-officeoffice-jsoffice-app

Auto-open does not work for people who have not signed in in browser

I want to share a document online by a URL with some colleagues. When they click the URL and view the document online, I want a task-pane add-in to be automatically opened.

I used Office-OOXML-EmbedAddin to create such a file with Script Lab auto-opened, then I put the file (view-only) on my OneDrive:

https://1drv.ms/x/s!AmAcI5jpNEmng1NhS0xbIMcUnUNZ

However, our tests show that, for people who have not signed in with Microsoft Account in their browser, the auto-open does NOT work, though they can view the document.

Is this behavior expected, given that people may not stay signed in all the time?

PS: note that if people download the document, they don't need to sign in to enable auto-open in Excel desktop.

Solution

  • This is a known bug. Until it is fixed, users will have to be logged in when they open a document on OneDrive in order for the autoopen feature to work. Sorry for the bad news, but it is on Microsoft's radar and we know it is important.