Fix a Gray Blank Sheet When Opening a SharePoint File in Excel
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.

- 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.
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.
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.
Go to the Microsoft 365 portal at microsoft365.com and sign in with the business account that should have access to the workbook.
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.
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.
After sign-in succeeds, return to the SharePoint workbook link and open the file again in Excel.

Test the workbook in a private window or another browser
Use a fresh browser session to check whether stored sign-in information is contributing to the problem.
Check the user's SharePoint file permissions
Use this when the affected user can sign in but still cannot access the workbook normally.
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.

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.




