Can't open excel file on SharePoint Online

Long, Alan 11 Reputation points
2021-09-28T10:59:57.227+00:00

We have uploaded some excel files to a SharePoint Online library with IRM setting enabled. Recently we cannot open some of the files in the library. It said "You are not signed in to Office with an account that has permission to open this workbook. You may sign in a new account into Office that has permission or request permission from......"
135903-image.png

When I click "Add Account", it shows MS login page
135922-image.png

After I login my account, which is an owner account of this SharePoint site and library, it shows
135914-image.png

May I know how to solve this issue? Thanks.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,687 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Echo Du_MSFT 17,141 Reputation points
    2021-09-29T03:27:06.873+00:00

    Hello @Long, Alan ,

    Welcome to Q&A Forum!

    This is expected behaviour. It occurs if you are trying to sign in using an Microsoft 365 account that is from the same organization as the Microsoft 365 account that is already logged in on your Computer or Office Desktop app.

    Please following steps:

    1.Sign out of the accounts (for the same domain) that are signed in, then restart that computer. If this solution does not resolve the issue, try the workaround below

    2.Workaround: Remove the existing user account and all connected services from your Office profile, and then clear cached credentials that may be on the computer

    Step1:Sign out of Office and then sign back in.

    Sign out of Microsoft Office using any Office product: Word, Excel, PowerPoint, Outlook, etc.

    • 1.Select File, and then select Account.
    • 2.Select Sign out.
    • 3.Close the Office product and then restart it.
    • 4.Select File, and then select Account.
    • 5.Select Sign in and use your credentials to sign back in.

    Step 2: Remove the user account from your Office profile

    • 1.On the upper-right corner of an Office app (Word, Excel, PowerPoint), select your name, and then select Switch Account.
    • 2.On the Accounts screen, select Sign out.

    136112-1.png

    • 3.Locate the account that you want to remove, and then select Sign out.

    Step 3: Remove connected services from your Office profile

    • 1.Go to File, and then select Account.
    • 2.Under Connected Services, remove all the services for the existing account.

    136122-2.png

    Step 4: Clear cached credentials on the computer

    a.Edit the registry to remove cached credentials:

    • 1.Select Start, select Run, type regedit, and then select OK.
    • 2.On Registry Editor, locate the following registry subkey:

    HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Common\Identity\Identities

    • 3.Select the Office account that you want to delete, and then select Delete.
    • 4.On the Identity subkey, locate Profiles, right-click the same Office account that you located in Step 1 of this procedure, and then select Delete.
    • 5.Select File and then Exit Registry Editor.

    b.Remove the cached credentials in Credentials Manager:

    • 1.Select Start, then Windows System, then open the Control Panel and select Credential Manager.
    • 2.Under the Windows Credentials tab, locate the account that you want to remove and then select Remove.

    136060-3.png

    • 3.Log off, and then log back in to the computer.

    Reference:

    "Sorry, another account from your organization is already signed in on this computer" in Office 2013

    Thanks,
    Echo Du

    =================================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.