How to Fix Excel History Grayed Out in Office 2019
Question details
Users are unable to access the 'History' option in Excel and Word 2019 as the button appears grayed out and unclickable for locally stored files.

- Product
- Microsoft Excel 2019
- Device & OS
- Windows
- Scenario
- Attempting to view or restore previous versions of a locally saved spreadsheet.
- Observed behavior
- The History option in the application interface is grayed out and unavailable for selection.
Ensure you have an external storage device (such as a USB flash drive, external hard drive, SD card) or access to a mapped network drive, as Windows File History requires a separate location to back up your local files.
Configure and Enable Windows File History
Use this solution to activate the native Windows feature that Office 2019 relies on for tracking local file history.
In Office 2019, the 'History' option is tied directly to the Windows File History feature rather than cloud-based versioning used by Microsoft 365. For this feature to work on locally saved files, Windows File History must be manually configured and turned on with an external or network drive.
Click the Windows Start menu, type 'File History' into the search bar, and select the 'File History' Control Panel app from the search results.
Connect your external USB drive, SD card, or click 'Select drive' in the left pane to choose an available external or network location.
Once a valid drive is selected, click the 'Turn on' button in the bottom right corner of the window. Excel will now be able to log file history for documents saved in your default Windows libraries.

Save the File to OneDrive or SharePoint
Use this method if you do not have an external drive and prefer to use Microsoft's cloud-based version history.
Use WPS Office for Hassle-Free Version History
If configuring external drives for Windows File History is too cumbersome, WPS Office provides a free, lightweight alternative with built-in backup and version history management, ensuring you never lose your progress.
- 1. Download and install WPS Office: Download WPS Office from the official website and install it on your computer.
- 2. Open your Excel file: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
- 3. Access Version History: Navigate to 'Menu' > 'Backup and Recovery' to easily manage local auto-backups and view previous versions without needing external hardware.

Frequently Asked Questions
Why is the History option available in Microsoft 365 but grayed out in Office 2019?
Microsoft 365 natively uses OneDrive and SharePoint for automatic, cloud-based Version History. Office 2019, however, relies on the Windows File History tool for locally saved files, which remains grayed out until configured with an external drive.
Can I use Windows File History on my main local hard drive without an external USB?
No, Windows File History requires a separate physical drive (like a USB or external HDD) or a mapped network location. It cannot back up files to the same drive where the original files are stored.
Will turning on File History recover older versions of my Excel file from before it was enabled?
No. Windows File History only begins tracking and saving versions of your files from the exact moment you turn it on. Any edits made prior to enabling the feature cannot be restored through this method.
How do I restore a previous version from Windows File History once it is enabled?
Open Windows File Explorer, navigate to where your Excel file is saved, right-click the file, and select 'Restore previous versions'. You can then select a timestamped version and click 'Restore'.




