SharePoint Document Issues

Fix Missing SharePoint Files and Excel Formatting Issues

Amos GikundaAmos Gikunda Nov 18, 2026 868 views

Question details

Determine why SharePoint folders appear empty in File Explorer and whether Excel files are losing formulas, margins, or formatting.

Fix Missing SharePoint Files and Excel Formatting Issues
Product
SharePoint Online, Microsoft Excel, and File Explorer
Device & OS
not provided
Scenario
Users access SharePoint files through a browser, Office desktop apps, or a File Explorer connection that may use WebDAV.
Observed behavior
Some Excel files appear to have lost formulas or formatting, while some SharePoint folders temporarily appear empty in File Explorer and reappear after a refresh.
Before you start

Identify an affected SharePoint folder and Excel file, and check whether the folder is accessed through a WebDAV connection. Have the SharePoint site address and access to the same file in a browser available for comparison.

Solution 1Recommended

Compare the SharePoint folder in a browser and File Explorer

Use this comparison to determine whether missing files are limited to the File Explorer connection.

1
Open the library online

In a web browser, open the SharePoint site and navigate to the affected document library and folder.

2
Compare the folder contents

Open the same folder in File Explorer and compare its contents with the SharePoint browser view. Record whether files are missing in one or both locations.

3
Refresh File Explorer

If the File Explorer folder appears empty, select the Refresh button or press F5, then check whether the files reappear.

Compare the SharePoint folder in a browser and File Explorer
Treat the symptoms separately: An empty File Explorer folder may be a connection or session issue rather than evidence that Excel formatting was deleted.
Free Microsoft Office alternative

Review Excel Workbooks with WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing local Office files. It can help you review a downloaded workbook, although it does not fix SharePoint or WebDAV connection issues.

Inspect formulas and formatting in downloaded workbooks.Compatible with Microsoft Excel XLSX and XLS formats.Familiar spreadsheet interface makes moving from Office straightforward.Free and lightweight for everyday document work.
microsoft office alternative - wps office

Frequently Asked Questions

Does an empty SharePoint folder in File Explorer mean the files were deleted?

Not necessarily. Open the same folder in the SharePoint browser view and refresh File Explorer. If the files remain visible online, the issue may be limited to the connection or folder view.

How can I check whether an Excel formula is still in a SharePoint file?

Open the workbook in Excel for the web, select the affected cell, and check the formula bar. Download a copy from the SharePoint library and compare the same cell in desktop Excel.

Where can I find an earlier version of a SharePoint workbook?

In the SharePoint document library, open the workbook's menu and select Version history. Inspect earlier versions if they are available.

What should I send Microsoft support about recurring empty folders?

Provide affected folder paths, timestamps, the number of users affected, browser comparison results, and whether the File Explorer connection uses WebDAV. Include file names and Office versions if workbook content is also affected.