'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel for the Web Showing Inverted Colors in SharePoint
Question details
A specific Excel workbook stored in SharePoint displays inverted colors when opened via Excel for the Web, but looks normal in the desktop app.
- Product
- Excel for the Web, SharePoint
- Device & OS
- not provided
- Scenario
- Opening a SharePoint-hosted Excel file in a web browser for online viewing or editing.
- Observed behavior
- The file displays with a black background, white or gray text, and missing gridlines, unlike other files in the same folder which display normally.
Before troubleshooting the workbook, verify if your web browser is currently using a forced 'Dark Mode' extension or high-contrast theme, as these can sometimes forcibly invert colors on specific web pages.
Create a Sanitized Copy for Testing and Support
Create a copy of the affected file without sensitive data to test if the issue persists in a fresh file, or to share with support teams for further investigation.
Often, display anomalies in a single web-hosted file are caused by hidden background formatting or localized corruption. By stripping sensitive data and saving a fresh copy, you can both test the rendering and safely share the file with technical support if needed.
Open the affected file from SharePoint using the Excel desktop application, where it currently displays normally.
Delete any confidential or proprietary data, leaving only the structural formatting and a few dummy data points.
Use 'Save As' to create a new copy of the workbook and upload it back to your SharePoint folder.
Open the newly uploaded sanitized file in Excel for the Web. If the colors are still inverted, share this sanitized file link via OneDrive or Dropbox with your IT support team.
Reset Worksheet Theme and Fill Colors
Resetting the background fill and document theme can clear any incompatible formatting that Excel for the Web might be rendering incorrectly.
Disable Browser Dark Mode Extensions
Browser extensions designed to make websites dark can misinterpret Excel's web canvas, causing the background to turn black and text to turn white.
Edit Spreadsheets Seamlessly with WPS Office
If Excel for the Web continues to have display rendering issues with your SharePoint files, consider using WPS Office. It provides a stable, highly compatible spreadsheet editor ensuring your formatting stays exactly as intended without browser glitches.
- 1. Download WPS Office: Visit the official WPS website and download the free desktop application for your operating system.
- 2. Install the Software: Run the downloaded installer and launch WPS Spreadsheets.
- 3. Open your File: Open your existing .xlsx file directly in WPS Office to view and edit without background color inversion issues.
Frequently Asked Questions
Why does only one Excel file show inverted colors in SharePoint?
This usually happens due to specific cell formatting, a custom workbook theme applied to that file, or a glitch in how the browser caches that specific file's web rendering data.
Does Excel for the Web have a built-in Dark Mode?
No, Excel for the Web does not currently support a native dark mode for the spreadsheet canvas. If your canvas is black, it is likely caused by a browser extension, OS-level high contrast settings, or file corruption.
How can I restore missing gridlines in Excel for the Web?
Go to the View tab in the Excel for the Web ribbon and ensure the 'Gridlines' box is checked. If they are still missing, check if the cells accidentally have a solid white fill color applied.
Can opening the file in the desktop app fix web display issues?
Yes, opening the file in the desktop application allows you to clear custom themes or fill colors that might be causing the web renderer to fail, then you can save it back to SharePoint.
