'%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)
How to Fix Excel for the Web Showing #### in Formula Cells
Question details
The user needs to resolve an issue where formula cells display '####' in Excel for the Web, even though the exact same SharePoint workbook calculates and displays correctly in the desktop version of Excel.
- Product
- Microsoft Excel for the Web
- Device & OS
- not provided
- Scenario
- Opening and viewing a shared SharePoint workbook in a web browser using Excel for the Web.
- Observed behavior
- Certain formula cells render as '####' in the web interface while the desktop application shows the correct calculated values.
Before modifying complex formulas or clearing formatting in your shared SharePoint workbook, download a local copy to your computer to safely test formatting changes without affecting the original file.
Adjust Column Width and Cell Formatting
The most common reason for the '####' display is that the column is too narrow to show the result, or there is a date/time format mismatch in the web interface.
Excel for the Web may render column widths and specific number formats slightly differently than the desktop application, causing the result to exceed the visual cell boundary.
Move your cursor to the column header (e.g., between columns C and D). When the cursor changes to a double-sided arrow, double-click the border to automatically expand the column width to fit the formula result.
Right-click the cell displaying '####' and select 'Number Format' from the context menu. If the cell is incorrectly formatted as a Date or Time (especially for negative numbers), change it back to 'General' or 'Number'.
Identify and Replace Unsupported Web Features
Excel for the Web does not support all the advanced array formulas, external data connections, or VBA-dependent calculations available in desktop Excel.
Use WPS Office for Unrestricted Formula Calculations
If you frequently encounter formula limitations or '####' display errors when viewing spreadsheets online, WPS Office offers a robust desktop experience. It processes complex formulas smoothly and prevents web-based rendering errors, serving as a powerful and free alternative to Microsoft Office.
- 1. Download and Install: Visit the WPS Office website and install the free suite on your PC or Mac.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your .xlsx file directly from your local drive or cloud storage.
- 3. View Accurate Results: Enjoy accurate formula calculations and proper column rendering without the limitations of a web browser.
Frequently Asked Questions
Why does a cell show #### instead of a standard error code like #VALUE!?
The #### symbol is primarily a presentation issue rather than a mathematical calculation error. It typically means the column is too narrow to display the numerical result, or a cell formatted as a date/time contains a negative value.
Does Excel for the Web support all desktop formulas?
No, Excel for the Web has calculation limits compared to the desktop app. While it handles most standard functions flawlessly, certain legacy array formulas, VBA macros, and deep external data links will fail to calculate or display correctly in the browser.
How can I share a workbook safely with Microsoft Support to troubleshoot this?
Make a copy of your workbook, delete any confidential or personally identifiable information, and save this sanitized version to OneDrive. You can then generate a shareable link to provide to Microsoft Support so they can inspect the unsupported formulas directly.
