Troubleshoot Missing Excel Changes and Files in SharePoint Online
Question details
Determine why Excel changes visible in version history are missing from the current document and why an uploaded file is no longer visible in a SharePoint library.

- Product
- SharePoint Online and Microsoft Excel
- Device & OS
- not provided
- Scenario
- Users edit older Excel files in the desktop app and store them in a SharePoint Online document library.
- Observed behavior
- Some changes appear in version history but not in the current file, and an uploaded file is missing from the library without a visible deleted or moved entry in recent history.
Note the affected file names and extensions, the library location, and when the changes or uploads occurred. Confirm that you can access version history and have permission to test files in another library or site.
Test the Excel files in another library and site
Use comparison tests to narrow the issue to the files, the original library, or the SharePoint site.
In the document library, check each affected file's full name and extension, such as .xls or .xlsx. Record whether it is edited in Excel for the web or the desktop app.
Create a new document library on the same SharePoint site, upload copies of the affected files, and edit and save them as usual. Reopen the files and compare the current content with Version history.
Upload copies to a document library on another SharePoint site, repeat the edit and save test, and check whether the changes remain visible after reopening.
Record where the issue occurs. If it follows the same files across libraries and sites, investigate the files; if it occurs only in the original library or site, ask a SharePoint administrator to investigate that location.

Compare version history and check for the missing file
Inspect available versions and library locations before asking an administrator to investigate.
Work with Excel Workbooks in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easier to move between office suites. It does not resolve SharePoint Online library or version-history issues.

Frequently Asked Questions
How can I compare an older Excel version with the current file?
In the SharePoint document library, open the workbook's More options menu and select Version history. Open the relevant version and compare its contents with the current workbook.
Where should I look if an uploaded file is missing?
Search the site for the file name, check library filters and folders, and inspect the site's Recycle bin. If the file is still missing, ask an administrator to check the second-stage recycle bin and available audit records.
Why test the same workbook in another library and site?
If the problem follows the workbook to both test locations, the file may be involved. If it occurs only in the original library or site, the results give an administrator a narrower location to investigate.
Can an older Excel file cause differences in Excel for the web?
Some older workbook features or formulas may not be supported in Excel for the web. Check the file extension and compare the affected formulas in the desktop app and the web; compatibility is only one possible factor.
What information should I send to SharePoint support?
Provide the file extensions, library and site test results, approximate times, and screenshots comparing the current workbook with the relevant version history. Mask private information in the screenshots.




