Permission & Access Issues

Fix a Gray Blank Sheet When Opening a SharePoint File in Excel

Muhammad TalhaMuhammad Talha Nov 13, 2026 868 views

Question details

A user needs to open a SharePoint workbook that appears as a gray blank sheet in Excel for one user but works for another.

Fix a Gray Blank Sheet When Opening a SharePoint File in Excel
Product
Microsoft Excel and SharePoint
Device & OS
not provided
Scenario
An affected user opens an Excel workbook from SharePoint while another user can open the same file normally.
Observed behavior
The workbook displays a gray blank sheet for the affected user. SharePoint sign-in may also reject the user's password.
Before you start

Have the affected user identify the business account that should have access to the SharePoint file. Keep the workbook link available and confirm that another authorized user can open it.

Solution 1Recommended

Verify Microsoft 365 and SharePoint sign-in

Use this first when the workbook works for another user or SharePoint rejects the affected user's password.

1
Sign in to Microsoft 365

Go to the Microsoft 365 portal at microsoft365.com and sign in with the business account that should have access to the workbook.

2
Test SharePoint access

Open SharePoint from the Microsoft 365 app launcher, then navigate to the site and workbook. Check whether other Microsoft 365 services also open with the same account.

3
Resolve sign-in errors

If the password is rejected, use the sign-in page's password reset option if available, or contact your Microsoft 365 administrator to restore account access.

4
Reopen the workbook

After sign-in succeeds, return to the SharePoint workbook link and open the file again in Excel.

Verify Microsoft 365 and SharePoint sign-in
Sign-in comes first: A SharePoint or account sign-in problem should be resolved before treating the gray screen as an Excel-specific issue.
Free Microsoft Office alternative

Work with Excel Workbooks in WPS Office

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move existing files into a new workflow. It does not resolve Microsoft 365 sign-in or SharePoint permission problems.

Open an authorized local copy of a SharePoint workbook in WPS SpreadsheetsCompatible with Microsoft Excel formats, including XLSX and XLSUse a familiar spreadsheet interface for an easier transition from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does the SharePoint workbook open for one user but show gray for another?

The affected user may have a different sign-in session or lack access to the file. Have them sign in at microsoft365.com with the correct business account, then check the workbook's SharePoint access.

What should I do if SharePoint does not accept my password?

Use the password reset option on the Microsoft 365 sign-in page if available, or contact your Microsoft 365 administrator. Resolve the account issue before continuing with Excel troubleshooting.

How can I check whether my browser session is causing the problem?

Open the workbook link in an InPrivate or Incognito window, or try another browser. Sign in with the correct business account and compare the result with the original browser.

Who can check whether I have access to the workbook?

Ask the file owner to select the workbook in SharePoint and open Manage access, or contact the SharePoint administrator. They can check whether your account has the required permission.

Can WPS Office fix my SharePoint sign-in?

No. Microsoft 365 sign-in and SharePoint permissions must be resolved through Microsoft or your administrator. WPS Spreadsheets can open an authorized local copy of the workbook after you obtain access.