Share via

Error with restricted access in Excel - "You do not have credentials that allow you to open this workbook."

Anonymous
2020-06-18T21:07:32+00:00

Hello, 

I built an excel model that has restricted access. The file is restricted based on user email. A select number of users are unable to open the report even though their emails have been correctly entered into the permissions window. Other users are able to open the report. 

For the users with errors, I had them check File > Account to ensure they were logged into the proper credentials. In all instances they were properly logged in but still unable to open this file. 

Each version of the model was shared via email, file type is an excel binary workbook and access type for the user is "change".

Are there any other possible scenarios that might be causing users to not be able to open the workbook?

I appreciate any and all insight you might be able to offer. 

Thanks,

Pat

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  2. Anonymous
    2020-06-19T03:19:10+00:00

    Hi Patrick,

    I have tested at my end and here are my test results:

    1.  If user signed in with the account which has permission to access, user can open this workbook and check the permissions without problem.

    1. If user try to open this workbook with another account, user will get error said this account doesn’t have permission to open it. 

     

     As you mentioned this issue only happens to specific users, I assume the possible reason is the credentials of the problematic user. You can suggest user follow these steps and check the result:

    1. Sign out all the account in Office application and quit application.
    2. Enter Credential Manager in search and Open it > Select Windows Credentials> Under the Generic Credentials, delete any items which are related to Microsoft Office.
    3. Restart PC and sign in with correct account, then try to open this workbook.

    Please feel free to share the result with us after testing. Thanks for your cooperation.  

    Best Regards,

    Ivy

    0 comments
  3. Anonymous
    2020-06-19T15:02:44+00:00

    Thank you, Ivy. I will follow up with one of the users exeperincing this issue today. I will provide him with his guidance and circle back with his response.

    0 comments
  4. Anonymous
    2020-06-20T07:04:03+00:00

    Hi Patrick, 

    You can feel free to share the result with us anytime. 

    We will try our best to assist. Thanks for your cooperation. 

    Regards,

    Ivy

    0 comments