'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Restore Blank Shared Excel Files After a Security Update
Question details
The user needs to recover data from shared Excel workbooks that appear completely blank after installing a recent software or security update.
- Product
- Microsoft Excel, OneDrive, SharePoint Online
- Device & OS
- not provided
- Scenario
- Opening and attempting to collaborate on a shared Excel workbook immediately following an Office or system security update.
- Observed behavior
- The shared Excel file opens successfully but the grid appears entirely blank, hiding or missing all previously saved content and formatting.
Ensure you have an active internet connection and the proper permissions to view and manage version history in the specific OneDrive for Business or SharePoint Online document library where the file is hosted.
Restore the Excel File using OneDrive or SharePoint Version History
Use the web-based version history feature in OneDrive or SharePoint to roll back the Excel file to a known working state from before the update.
Because shared workbooks are hosted on Microsoft's cloud servers, their version history is automatically maintained. Restoring an older version is the most reliable method for retrieving missing data when a localized update causes files to render as blank.
Navigate to your OneDrive for Business or SharePoint Online document library using a web browser and find the affected Excel file.
Right-click on the blank Excel file and select 'Version history' from the drop-down context menu.
Review the list of saved versions. Identify a timestamp from immediately prior to the security update, click the three-dot menu icon next to it, and click 'Restore'.
Enable and Review Track Changes (Legacy)
If the file isn't completely blank but is missing substantial entries, use the legacy Track Changes feature to identify destructive modifications.
Prevent Update Glitches by Switching to WPS Office
If forced updates frequently disrupt your workflow with blank screens and sync errors, consider switching to WPS Office. It delivers a highly stable, seamless environment for all your spreadsheet tasks without disruptive background updates.
- 1. Download WPS Office: Visit the official WPS website and download the free installation package for your operating system.
- 2. Install and Launch: Run the installer, follow the quick setup prompts, and open the WPS Office desktop application.
- 3. Open Your Excel File: Drag and drop your existing .xlsx shared workbooks directly into the WPS workspace to securely view and edit your data.
Frequently Asked Questions
Why do my shared Excel files appear blank after a security update?
Security updates can occasionally interfere with Excel's display rendering engines or local cache when syncing with SharePoint or OneDrive. This causes the application's interface to draw a blank grid despite the underlying data and file size remaining perfectly intact.
Will restoring a previous version delete new changes made by my colleagues?
Yes. When you restore an older version of a shared workbook via OneDrive or SharePoint, the file rolls back entirely. Any subsequent edits or data entered by you or your collaborators after that specific version's timestamp will be overwritten.
Can I view version history directly within the Excel desktop app?
Yes, provided you are signed into your Microsoft 365 account and the file is synced to OneDrive or SharePoint. Simply click on the file's name at the top center of the Excel window and select 'Version History' to browse past states in a right-hand side panel.
