'%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 Embedded Excel Workbook Showing ### on Mobile Devices
Question details
Calculated cells within an embedded interactive Excel workbook display as '###' when viewed on mobile devices, particularly through OneDrive, despite working correctly on desktop browsers.
- Product
- Microsoft Excel, OneDrive
- Device & OS
- Mobile (iOS/Android)
- Scenario
- Viewing an embedded interactive Excel spreadsheet via a mobile web browser or the OneDrive mobile interface.
- Observed behavior
- Calculated cells fail to render the numbers properly and instead display '###' error symbols.
Ensure your mobile browser is updated to the latest version and verify if the original workbook's columns are wide enough to accommodate the data on smaller screens.
Open the Workbook in the Native Mobile App
Since mobile browsers and web viewers often have limitations rendering complex interactive elements, opening the file directly in the native spreadsheet app is the most reliable workaround.
Mobile web viewers, including OneDrive's mobile interface, frequently struggle to process calculated cells and dynamic column widths in embedded workbooks. Bypassing the browser viewer resolves most rendering issues.
Ensure you have a native spreadsheet application installed on your iPhone or Android device.
Navigate to the website or OneDrive folder containing the embedded workbook using your mobile browser.
Look for an option or icon that says 'Open in App' or 'Open in Excel', usually located at the bottom or top right corner of the embedded frame, to launch the file natively.
Widen Columns in the Source File
The '###' symbol is standard spreadsheet behavior when a column is too narrow to display its contents. Mobile screens may scale columns differently than desktop browsers.
Adjust Embed Settings or Use Alternative Services
If forcing users to download an app is not an option, you may need to adjust the website's embed parameters or use a more mobile-friendly data hosting service.
Use WPS Office for Seamless Mobile Spreadsheet Viewing
If Microsoft OneDrive and mobile browsers struggle to display your embedded workbooks correctly, consider using WPS Office. It provides a lightweight, highly compatible alternative for viewing, editing, and sharing complex spreadsheets on mobile devices without unexpected rendering errors like '###'.
- 1. Download WPS Office: Get the free WPS Office app from the App Store or Google Play Store.
- 2. Open the Spreadsheet: Locate and open your file via the built-in file manager or by linking your cloud storage.
- 3. View without errors: Enjoy perfect formatting and accurate calculation displays without the '###' column width errors.
Frequently Asked Questions
Why do cells show '###' in an embedded spreadsheet?
This usually indicates that the column is too narrow to display the full numerical value, or a date/time calculation has resulted in a negative number. Increasing the column width in the source file typically resolves this.
Why does the workbook display perfectly on a desktop browser but fail on a mobile browser?
Mobile browsers and mobile OneDrive viewers use different rendering engines that may automatically scale or condense tables to fit smaller screens. This automatic scaling often causes columns to become too narrow for the calculated data, resulting in the '###' display.
Can I fix this issue without forcing users to install a mobile app?
Yes, you can try widening the columns significantly in the original Excel file before embedding it. Alternatively, ensure your website's embed code is configured for responsive mobile scaling, or provide a direct download link so users can access the raw file.
