Version management - major and minor

%3CLINGO-SUB%20id%3D%22lingo-sub-1871553%22%20slang%3D%22en-US%22%3EVersion%20management%20-%20major%20and%20minor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1871553%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EHi%2C%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20document%20libary%20with%20several%20files.%20It%20is%20possible%20to%20save%20changes%20in%20the%20documents%20like%20minor%20og%20major%20versions.%20I%20only%20want%20to%20open%20the%20latest%20major%20version%20(used%20for%20an%20excel%20power-query%20tabel).%20Is%20there%20some%20easy%20kind%20of%20settings%20to%20do%20that%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1871553%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESites%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1872816%22%20slang%3D%22en-US%22%3ERe%3A%20Version%20management%20-%20major%20and%20minor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1872816%22%20slang%3D%22en-US%22%3ENot%20sure%20if%20I%20follow%20you%20hare....do%20you%20mean%20that%20if%20you%20have%20major%20and%20minor%20versions%2C%20it%20might%20be%20that%20a%20minor%20version%20is%20opened%20instead%20of%20the%20major%20one%3F%20If%20that's%20the%20case%3A%20what%20about%20using%20the%20minimum%20permissions%20to%20collaborate%20on%20the%20file%20so%20minor%20versions%20are%20not%20considered%3F%3C%2FLINGO-BODY%3E
New Contributor

Hi,

 

I have a document libary with several files. It is possible to save changes in the documents like minor og major versions. I only want to open the latest major version (used for an excel power-query tabel). Is there some easy kind of settings to do that?

 

Thanks.  

2 Replies
Not sure if I follow you hare....do you mean that if you have major and minor versions, it might be that a minor version is opened instead of the major one? If that's the case: what about using the minimum permissions to collaborate on the file so minor versions are not considered?

@Juan Carlos González Martín 

 

I have an Excel sheet in my document libary. This sheet have a lot of minor versions and major versions. 

 

For example:

 

11-11-2020  Minor

11-10-2020  Major

11-09-2020  Minor

11-08-2020  Major

 

In this case I want the data from latest major version = 11-10-2020.

If i import data from the web-link on sharepoint into my Power Query (Excel) I get the data from 11-11-2020 minor...