Forum Discussion
Revision (or Version) Control.
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.
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
2 Replies
- Patrick2788Silver Contributor
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
- Martin-123Copper Contributor
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.