How to Number Major and Minor Excel Revisions
Question details
The user wants to number major and minor revisions of an Excel workbook.

- 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.
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.
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.
Open the SharePoint document library, select Settings, and then select Library settings.
Open Versioning settings and select Create major and minor versions. Adjust any available draft visibility or retention settings, then save your changes.
Upload the Excel workbook to the configured library or use Excel's Save As command to save it there.
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.

Use custom revision labels for local Excel files
Use separate file names when you need a specific revision format without SharePoint-managed versioning.
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.

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.




