Fix Missing SharePoint Files and Excel Formatting Issues
Question details
Determine why SharePoint folders appear empty in File Explorer and whether Excel files are losing formulas, margins, or formatting.

- 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.
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.
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.
In a web browser, open the SharePoint site and navigate to the affected document library and folder.
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.
If the File Explorer folder appears empty, select the Refresh button or press F5, then check whether the files reappear.

Compare Excel formulas and formatting in a downloaded copy
Use Excel and a downloaded file to check where a workbook's formulas, margins, or formatting differ.
Investigate recurring WebDAV folder disappearances
Use these checks when SharePoint folders repeatedly appear empty through a File Explorer connection.
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.

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.




