Excel Versioning - delete and/or disable in specific files

Question

Hello, 

I am happy with the existence of versioning in Excel as, with the automatic save, it allowed me to recover work (or revert) at a later stage.

However, in most cases I do not want to show those versions (or all of them) to a third party. How can I delete part or all the versions in a file.

On the same note, there are some specific files that I do not any version to exist. Is there a way to disable versioning altogether in specific files?

Thanks, N

Answer 1

Hi nsgma365,

Thanks for posting in our forum.

For the function of version history for a Word document or Excel workbook, it is only available to use when the file is saved in OneDrive or SharePoint. For your reference: View previous versions of Office files (microsoft.com)

 

Hence, if you want to disable this function for some specific files, kindly save them to a local position on your PC and they will no longer have the function of version history. Also, all the files created in local position will not have this function automatically as they are not connected to OneDrive or SharePoint before.

For the first concern, an easier workaround for you is to save the final edition of a document as a copy(which is a good way to prevent some kind of data leaks) and then send out this local file to others or a third party as normal.

Hope above suggestions could meet your scenario, but please feel free to post back if you need further help.

Best Regards,

Mia

Answer 2

Hi nsgma365,

Please let me know if you need further help.

Best Regards,

Mia