SharePoint Document Issues

Fix Excel Files Losing Data and Charts When Opened in SharePoint

Bushra ParveenBushra Parveen Nov 4, 2026 871 views

Question details

Users encounter errors, and charts or worksheet data disappear when opening Excel reports stored in SharePoint.

How to Fix Excel Files Losing Data and Charts When Opened 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.
Before you start

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.

Solution 1Recommended

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.

1
Open the file locally

Download a copy of the affected Excel file from the SharePoint library and open it directly in the Excel desktop application.

2
Rename worksheets

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.

3
Identify web-unsupported elements

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.

4
Re-upload to SharePoint

Save the corrected file and upload it back to the SharePoint document library, replacing the problematic version.

Remove Apostrophes from Sheet Names and Check for Unsupported Features
Tip: Always advise end users to open complex workbooks using the 'Open in Desktop App' option rather than viewing them in the browser to prevent data rendering issues.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download and install WPS Office for free.
  2. 2. Open the Spreadsheet: Launch WPS Spreadsheet and open your downloaded .xlsx file to view all charts and data perfectly intact.
  3. 3. Edit and Save: Make your necessary edits and save the file in its original format without worrying about unsupported feature errors.
Highly compatible with Microsoft Excel (.xls, .xlsx) files, preserving all charts and data.Lightweight software that opens large data files quickly without crashing or dropping content.Free to use with a familiar, easy-to-navigate user interface.Built-in cloud support for easy team collaboration, file sharing, and version management.
microsoft office alternative - wps office

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.