SOLVED

Revision (or Version) Control.

New Contributor

Hi,  I'm using a spreadsheet to send data to several colleagues. There will be many revisions of the data. Is there a feature within Excel (Version 16.43), that enables each revision to be sequentially numbered for major and minor revisions?  eg;

 

Rev 01.01

Rev 01.02

Rev 01.03

Rev 02.00

Rev 02.01

etc.

 

Many thanks.

2 Replies
best response confirmed by Hans Vogelaar (MVP)
Solution

@Martin-123 

Versioning is available if you're storing workbooks (and other Office files) in the Cloud (SharePoint or OneDrive).

You have to enable Major and Minor versioning in Library (for document libraries) or List settings:

Patrick2788_0-1661353063137.png

 

More details on versioning: Versioning in SharePoint | Microsoft Docs

 

Thank you @Patrick2788 

 

Unfortunately, I'm not using the cloud, etc. I'll be sharing, and storing, it on github.

 

I guess that's the end of that! Haha!

 

I'll just have to do it manually.

 

Thank you.