Fix Excel constantly asking you to sign in

Microsoft Excel is a spreadsheet tool developed by Microsoft that utilizes formulas and functions to arrange numbers and data. Excel analysis is used by organizations of all sizes all around the world to do financial analysis. However, it’s not without issues and problems which will inconvenience users on a day-to-day basis especially if you use Excel quite a lot. The error were will discuss is when each time a user opens Excel or Word, it keeps prompting them to input an Office account password to gain access to the documents. This can be frustrating and leave the user quite inconvenient having to manually input the password each time they open a document. This can be a license issue or a security issue, each issue can lead to you having to alter the password to gain access to a document. In this blog, we will be looking at solutions to help users resolve “Fix Excel constantly asking you to sign in” and find possible solutions to help prevent the error from occurring again. We will also address some of the issues that can cause “Fix Excel constantly asking you to sign in” so users are more aware of what they are dealing with and what approaches they need to take to resolve “Fix Excel constantly asking you to sign in”. Follow the step-by-step process below to see how you can resolve “Fix Excel constantly asking you to sign in”.

Step by step process – How to fix Excel constantly asking you to sign in

  1. Firstly, click on “Start”.
  2. Type in “Run”.
  3. Click the “Run” app.
  4. Input the following “rundll32.exe keymgr.dll, KRShowKeyMgr”.
  5. Remove the credentials.
  6. Click on “Close”.
  7. Now open “Excel” again and type out your normal login details.

That’s it, once you have followed the steps above you will have resolved the error “Fix Excel constantly asking you to sign in”. When you first sign in your details are stored in the credential folder where most if not all your password-based information is managed. Over time this information may get overwritten by new credentials if you have say signed in with a new account and are using Excel from this account. Once you remove the credentials and retype them, they will be replaced in the credential folder and therefore it will be reset. This will now no longer ask for a password to access the account.

The problem is that the password is stored in the file to which Excel is attempting to connect. Excel is being extra cautious, ensuring that you have the correct password in order to access the data from the file to which your spreadsheet is attached.

If you open a spreadsheet that you know doesn’t have a password and see a screen like this, it implies Excel is attempting to link to and extract data from a password-protected spreadsheet.

excel basics advanced excel excel workbook

Alternate tips to fix the issue – Excel constantly asking you to sign in

Use credential manager

Windows Credential Manager is a user-friendly password manager that makes it simple to handle sensitive data. However, there have been concerns about hackers gaining access to passwords that have been kept.

Passwords are saved in clear text in the Credentials Manager file format, making them easy to exploit if a hacker gains access to your system via elevated access (Local Administrator or System-level access on your device).

Certificate-Based Credentials, which are typically utilized in a sophisticated business network environment, are included in Windows Credentials. These aren’t required by the majority of users. However, you can learn more about utilizing third-party certification authority to enable more sophisticated certificate-based credentials on the Microsoft support sites.

Installed app information that allows your computer or others on the network to utilize the appropriate apps is also included in the Windows Credentials category. As a result, Windows Credential Manager is a simple method to handle sensitive information needed for daily tasks and inside shared networks.

surface pro 8Surface Go 3surface pro 8

Delete any shared calendars that are no longer in use.

Due to an outdated shared calendar, some users claimed that Office constantly requested them to sign in. The calendar was apparently created as a SharePoint list, which resulted in the log in difficulty.

To resolve the issue, users just had to delete the calendar, and the issue was resolved. Delete any old shared calendars that you aren’t using, and the problem will be fixed.

Enable encryptions

Users claim that if the encryption function isn’t turned on, this problem might occur. Encryption is recommended for keeping your emails safe from outside parties.

Several consumers said that by not utilizing encryption, Office kept prompting them for their password on their PC.

Manually enter the associated passwords

The Credentials Manager saves all of your passwords on your computer, however, it can occasionally malfunction. Certain apps, such as Microsoft Office and Outlook, may have difficulties as a result of this.

If Office continues prompting you to sign in, try the following steps to resolve the issue:

  • Open the Credential Manager application. Solution 1 explains how to accomplish it in detail, so go there for more information.
  • Once the Credential Manager is open, manually input your password in all areas where your email address is saved. Close Credential Manager after saving your changes.
  • Enter “percent local app data percent” by pressing Windows Key + R. Click OK or press Enter.
  • Go to the Microsoft outlook directory and open it. Find the file Autodiscover.xml. Don’t be fooled by the fact that this file’s name may contain an array of characters and numbers. Rename or move this file to a new place.
  • Launch Outlook after that, and it should start without any prompts.

In-depth – Step by step process – How to fix Excel constantly asking you to sign in

  • Firstly, click on “Start”.
  • Type in “Run”.
  • Click the “Run” app.
  • Input the following “rundll32.exe keymgr.dll, KRShowKeyMgr”.
  • Remove the credentials.
  • Click on “Close”.
  • Now open “Excel” again and type out your normal login details.

That’s it for this Blog thank you for taking time out to read our content, please feel free to email our team about how it went if you followed the steps or if you need more help with the questions we answered in this Blog.

Saajid Gangat

Saajid Gangat has been a researcher and content writer at Business Tech Planet since 2021. Saajid is a tech-savvy writer with expertise in web and graphic design and has extensive knowledge of Microsoft 365, Adobe, Shopify, WordPress, Wix, Squarespace, and more! You can connect with Saajid on Linkedin.

Recent Posts