Version History Issues

How to Fix Excel History Grayed Out in Office 2019

Amos GikundaAmos Gikunda Oct 20, 2026 870 views

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.

How to Fix Excel History Grayed Out in Office 2019
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.
Before you start

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.

Solution 1Recommended

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.

1
Open File History settings

Click the Windows Start menu, type 'File History' into the search bar, and select the 'File History' Control Panel app from the search results.

2
Select a backup drive

Connect your external USB drive, SD card, or click 'Select drive' in the left pane to choose an available external or network location.

3
Turn on File History

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.

Configure and Enable Windows File History
File Location Requirement: Windows File History only backs up files located in specific folders like Documents, Music, Pictures, Videos, and Desktop. Ensure your Excel file is saved in one of these locations.
Free Microsoft Office alternative

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. 1. Download and install WPS Office: Download WPS Office from the official website and install it on your computer.
  2. 2. Open your Excel file: Launch WPS Spreadsheet and open your existing .xlsx or .xls file.
  3. 3. Access Version History: Navigate to 'Menu' > 'Backup and Recovery' to easily manage local auto-backups and view previous versions without needing external hardware.
100% free and lightweight alternative to Microsoft Office.Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Built-in Local and Cloud Backup features that don't require external drives.Familiar user interface makes switching completely seamless.
microsoft office alternative - wps office

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'.