Fix Excel Files Losing Data and Charts When Opened in SharePoint
Question details
Users encounter errors, and charts or worksheet data disappear when opening Excel reports stored in SharePoint.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Opening shared Excel reports containing charts and data from a SharePoint document library.
- Observed behavior
- Errors appear during the file opening process, and specific worksheet data or charts are lost or stripped from the file.
Ensure you preserve a backup of the original Excel file and review the SharePoint version history to restore a previous working state before applying any modifications.
Remove Apostrophes from Sheet Names and Check for Unsupported Features
Special characters in sheet names, specifically apostrophes, or unsupported web features can cause Excel to drop data when opened from SharePoint.
Excel for the Web and SharePoint synchronization can struggle with specific special characters in worksheet tabs. Additionally, certain legacy charts or complex data structures may not render correctly in the browser, causing the application to strip them upon opening.
Download a copy of the affected Excel file from the SharePoint library and open it directly in the Excel desktop application.
Review all worksheet tabs at the bottom of the Excel window. If any sheet name contains an apostrophe ('), right-click the tab, select 'Rename', and remove the character.
Check if the document contains legacy drawing objects, unsupported chart types, or complex macros that might cause the web viewer to strip content when opened in Excel for the Web.
Save the corrected file and upload it back to the SharePoint document library, replacing the problematic version.

Test the Excel File in a Different Document Library
Library-specific settings, permissions, or corruption can interfere with Excel file rendering. Testing in a new library isolates the issue.
Try WPS Office for Seamless Spreadsheet Management
If SharePoint and Microsoft Excel continue to cause data loss, rendering issues, or browser limitations, consider using WPS Office as a lightweight, free alternative. WPS Spreadsheet offers excellent compatibility with Microsoft Excel formats and handles complex charts and data reliably.
- 1. Download WPS Office: Visit the official WPS website to download and install WPS Office for free.
- 2. Open the Spreadsheet: Launch WPS Spreadsheet and open your downloaded .xlsx file to view all charts and data perfectly intact.
- 3. Edit and Save: Make your necessary edits and save the file in its original format without worrying about unsupported feature errors.

Frequently Asked Questions
Why does Excel for the Web show different data than the desktop app?
Excel for the Web has certain limitations and might not support advanced features, legacy charts, or complex macros present in the desktop version. When it encounters unsupported features, it may display errors or omit the content entirely.
How can I recover the lost data in my SharePoint Excel file?
You can recover previous data using SharePoint's Version History. Right-click the affected file in the SharePoint library, select 'Version history', and restore a version saved before the data loss occurred.
Can special characters in my workbook cause SharePoint errors?
Yes. Special characters like apostrophes (') in worksheet tab names or unsupported symbols in the file name can cause synchronization and rendering errors when opening files in SharePoint or Excel for the Web.




