'%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 Delete All Excel Workbook Version History
Question details
The user needs to delete the version history of an Excel workbook to free up OneDrive storage space.
- Product
- Microsoft Excel (OneDrive / SharePoint)
- Device & OS
- not provided
- Scenario
- An Excel file has accumulated over 20,000 versions, consuming hundreds of gigabytes of cloud storage space.
- Observed behavior
- The user requires a method to bulk delete all file versions to recover storage space, acknowledging that the deletion is completely irreversible.
Before deleting any version history, ensure you have a final, working copy of your Excel workbook saved locally, as this deletion is completely irreversible and removes all file recovery options.
Delete Version History via OneDrive or SharePoint Web Interface
The most direct method to delete all version history for a specific Excel workbook is through the OneDrive or SharePoint web portal.
By accessing your cloud storage through a web browser, you can manage the file properties directly and clear out all historical versions of the workbook to instantly recover storage space.
Open your web browser and log in to your OneDrive or SharePoint account.
Navigate to the specific folder containing the Excel workbook that is consuming excess storage.
Hover over the Excel file, click the three-dot menu icon (Show actions), and select 'Version history' from the dropdown menu.
In the Version history pane, look for the option to 'Delete all versions'. If a bulk deletion option is not visible, you may need to delete older versions individually or consult your IT admin.
Click to confirm the deletion when prompted, keeping in mind that previous states of the file can no longer be recovered.
Create a Fresh Copy to Reset Version History
If bulk deletion of version history is restricted by your admin, creating a brand new copy of the file will reset the version count to zero.
Switch to WPS Office for Efficient File Management
Tired of dealing with bloated cloud storage files and complex version history settings? WPS Office is a free, lightweight alternative to Microsoft Office that offers full compatibility with Excel formats and provides an intuitive, user-friendly experience.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device in minutes.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx files with complete format and formula compatibility.
- 3. Save and Manage with Ease: Edit and save your documents smoothly without the burden of uncontrollable background version bloating.
Frequently Asked Questions
Can I recover an Excel version after I delete the version history?
No, deleting the version history of an Excel workbook in OneDrive or SharePoint is a permanent and irreversible action. Once deleted, those previous file states cannot be restored.
Why does my Excel file have so many versions?
Excel's AutoSave feature frequently saves incremental changes to OneDrive or SharePoint. If a workbook is left open for long periods or collaborated on continuously by multiple users or scripts, it can rapidly generate thousands of versions over time.
Can I delete specific versions instead of all of them?
Yes. In the Version history pane on OneDrive or SharePoint, you can click the ellipsis (three dots) next to a specific older version and choose 'Delete' to remove just that instance, though this can be very tedious for files with thousands of versions.
Does deleting version history affect my current file?
No, deleting the version history only removes the older, saved backup states of the file. Your current, most recently saved version of the Excel workbook remains completely intact and accessible.
