Version History Issues

How to Number Major and Minor Excel Revisions

Natalie TaylorNatalie Taylor Nov 18, 2026 868 views

Question details

The user wants to number major and minor revisions of an Excel workbook.

How to Number Major and Minor Excel Revisions
Product
Microsoft Excel and SharePoint
Device & OS
not provided
Scenario
The user needs to distinguish major releases from minor changes to a workbook.
Observed behavior
Ordinary local Excel files do not have a built-in major-and-minor revision numbering system; cloud version history is available through SharePoint or OneDrive.
Before you start

Decide whether you need SharePoint-managed versions or custom labels such as Rev 01.01. To configure SharePoint versioning, you need permission to change the document library settings.

Solution 1Recommended

Enable major and minor versions in a SharePoint library

Use SharePoint versioning to track drafts and published releases of an Excel workbook.

SharePoint assigns its own version numbers. If you need a specific format such as Rev 01.01, record that label separately in the file name or document metadata.

1
Open the library settings

Open the SharePoint document library, select Settings, and then select Library settings.

2
Configure versioning

Open Versioning settings and select Create major and minor versions. Adjust any available draft visibility or retention settings, then save your changes.

3
Save the workbook

Upload the Excel workbook to the configured library or use Excel's Save As command to save it there.

4
Review and publish versions

In the library, open the workbook's More options menu and select Version history to review revisions. Use the library's Publish option to publish a major version when it is available.

Enable major and minor versions in a SharePoint library
Check library permissions: Versioning and publishing options depend on the library configuration and your permissions. Ask the library owner if you cannot change the settings or publish a version.
Free Microsoft Office alternative

Manage Excel-compatible workbooks with WPS Office

WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets. Open existing Excel files and use custom revision labels in file names as you move your work to WPS. SharePoint versioning settings must still be managed in SharePoint.

Free and lightweight spreadsheet editingCompatible with Microsoft Excel formats, including XLSXUse custom revision labels in workbook file namesFamiliar interface helps make the move from Microsoft Office easier
microsoft office alternative - wps office

Frequently Asked Questions

Can Excel automatically assign major and minor numbers to local files?

No. Ordinary local Excel files do not have a built-in major-and-minor revision numbering system. Use SharePoint library versioning or add revision labels manually with File > Save As.

Where can I see earlier versions of a workbook?

For a workbook stored in SharePoint or OneDrive, open its More options menu and select Version history. The available versions depend on the storage location and its settings.

Can SharePoint use a custom format such as Rev 01.01 for version numbers?

SharePoint assigns its own version numbers. If you need a format such as Rev 01.01, record it separately in the file name or document metadata.

Why can't I enable major and minor versions in SharePoint?

Changing the setting requires permission to manage the document library. Open Library settings > Versioning settings, or ask the library owner to configure it.