Forum Discussion

Walter Pelowski's avatar
Walter Pelowski
Brass Contributor
Jul 03, 2018

View Previous Excel Spreadsheet Version in SharePoint Online without Restoring

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 gue...
Requests
Sharing & Publishing
JKPieterse's avatar
JKPieterse
Silver Contributor
Jul 04, 2018
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)
Walter Pelowski's avatar
Walter Pelowski
Brass Contributor
Jul 24, 2018

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.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jul 25, 2018
    But you've just created a copy of the original version so the copy *is* the original version is it not?
    • Walter Pelowski's avatar
      Walter Pelowski
      Brass Contributor
      Aug 03, 2018

      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.

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Aug 24, 2018
        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.

Resources