Why an Excel Hyperlink Opens a Sign-In Page
Question details
The user wants to understand why an Excel hyperlink opens a sign-in page instead of the expected destination.

- Product
- Microsoft Excel and SharePoint
- Device & OS
- not provided
- Scenario
- Opening a hyperlink in an Excel workbook that may point to a protected SharePoint site or another Microsoft service.
- Observed behavior
- The hyperlink opens a login page rather than showing the destination immediately.
Identify the account you expect to use for the linked resource, and check whether the sign-in page belongs to a trusted service before entering credentials. If the page looks unfamiliar, ask the link owner to verify it.
Check the hyperlink destination and sign in
Use this approach when the link points to SharePoint or another service that requires authentication.
In Excel, right-click the linked cell and select Edit Hyperlink to review the address. If the link appears in a formula, select the cell and check the formula bar.
Open the hyperlink and check the browser address bar for the expected service or organization. Do not enter credentials if the address looks suspicious.
On the trusted sign-in page, sign in with the work, school, or personal account that has access to the destination. If prompted, complete any additional verification.
On a trusted device, use your browser's offer to save the password or the service's stay-signed-in option if permitted. These options may not prevent prompts required by your organization's policies.

Ask the link owner to check access and sharing
Use this if the correct account cannot open the destination or the link was expected to work without signing in.
Open and Edit Excel Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing Office files. Its format compatibility makes it easy to move existing workbooks, though protected links still require the appropriate sign-in and permissions.

Frequently Asked Questions
Why does a SharePoint link in Excel ask me to sign in?
SharePoint may require authentication before showing the linked file or site. Sign in with an account that has permission to access it.
How can I see where an Excel hyperlink goes?
Right-click the linked cell and select Edit Hyperlink to inspect its address. If the cell uses a HYPERLINK formula, select it and review the formula bar.
What if I sign in but still cannot open the file?
Use Request access if it appears, or ask the file owner to check your account's permissions in SharePoint or OneDrive using Share.
Can I stop the sign-in page from appearing every time?
On a trusted device, you can use the browser's password-saving feature or a stay-signed-in option if available. Organization policies or expired sessions may still require you to sign in again.
Can the owner make the link available without signing in?
The owner can check the Share options for an anonymous sharing link, but that option may be disabled by the organization's policies or unavailable for the resource.




