Forum Discussion
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...
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.
- 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.