View Previous Excel Spreadsheet Version in SharePoint Online without Restoring

Brass Contributor

Due to the new AutoSave option in Excel (which I've turned off by default) my colleagues are inadvertently making changes to Excel spreadsheets that they're essentially only trying to review.  My guess (from speaking with them) is that they're just enabling certain table filters or slicers in the data, or  perhaps resorting records as they review certain spreadsheets.  However, I can't really be sure that no data has changed and that has me concerned.

 

Ultimately, I want to compare their version with the previous version to review what has changed.  While Microsoft Word for Office 365 has great mechanisms for doing this, understandably spreadsheets are a different beast and that sort of web-based comparison doesn't seem to be available yet.  What I'd like to be able to do is take the previous version (download it if I have to) and compare it against the current version.  And in the long-term I've reduced the permissions for the document library folder so more people have just "View" permissions but no "Edit" permissions.

 

Here is a image of screenshots that shows what I'm running into.

https://www.screencast.com/t/1bT6y33C0t

 

Any help for a better workflow or suggestions on what we should be doing would be appreciated.  This is pricing documentation and while I want people to quickly review it, I don't want any edits to be made unless they're reviewed by multiple people and approved.

9 Replies
ONe way to achieve getting both the current version and restoring an old copy without loosing the current is to first copy the current version (click three dots next to file, select Copy to)

Jan,

 

  I don't see how that will work because when I do a "Copy to" it doesn't copy the version history as well.  So a Copy To only gives me the latest copy and I don't want to revert the original to the previous version (for comparison) because I may want to keep the latest version.

But you've just created a copy of the original version so the copy *is* the original version is it not?

I'm not sure what you're saying.  If I make a copy of the spreadsheet (which already has multiple versions saved for it) it's the latest version of that spreadsheet.  So if you mean by "original" that it is (before I create the copy) the only file for that spreadsheet in the system (once again with it's many versions) than yes.  But it's not the original version in that the spreadsheet has had multiple versions saved for it.

 

So, if within that spreadsheet there are multiple versions, I can't compare two versions of the same spreadsheet because to do that (as far as I'm aware) I need to first revert to a previous version (which I'm not yet sure I want to do) just to compare two versions of the same sheet to one another.

I see your problem. Making a copy and then reverting the original to an older version (so you can comparre the two) destroys your version history for the copy of the original. So if you decide to not keep the older version but prefer the latest version you have a problem. I don't know how to resolve this right now I'm afraid.

Have you tried setting the library to require checkout.  That way, they can still open the file, but if they want to open it for editing, they have to check it out.  You would also have to educate the users on when to click "Check Out" at the top of the screen, but it might work for you.

Bob,

 

  Yes, I have considered that.  Unfortunately these files exist in a larger document library and because requiring a checkout is for the whole document library, it would affect everyone's files, which is not what we want.  Had I had the foresight to know this, I would've created a separate document library for just these files but as is the case with a lot of these types of things, it was a situation where a person (in this case, myself) inherited what was already there and the needs/demands of the project have increased over time.

 

  While I wish I could just move these files to a new document library, I don't think that option (of maintaining the versions/history of the files while moving them to a new place) is available yet.

Thanks Jan for trying to help me solve this; that's kinda what I figured. I really wish there was an option for this. Comparing two different versions of a spreadsheet in a document library seems like it would be a common need across customers.
A little late to the party but as I had similar problem and found only this solution I think I'll say how I managed to get the old version (without messing up the version history of the original one). There is an option on SharePoint to use it in "Classic Experience" mode. In this mode you can access version history and actually download the old version by using 'save as' or 'open in new tab' option (really similar how it's described in this really old thread: https://sharepoint.stackexchange.com/questions/29008/how-do-i-view-the-older-version-of-the-document...).