Revision (or Version) Control.

[Martin-123]

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 · Accepted 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:

More details on versioning: Versioning in SharePoint | Microsoft Docs

[#3]

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.