­
How to retrieve an older version of an Excel spreadsheet — ICT & Computing in Education
  • Front Page
  • Search
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
Menu

ICT & Computing in Education

Articles on education technology and related topics
  • Front Page
  • Search
  • Newsletters
    • Digital Education
    • Terry Freedman's Books Bulletin
  • RSS
  • Info
    • Welcome
    • The "About" Page
    • Testimonials
    • CV/Resumé
    • My Writing
    • Published articles
  • Corrections Policy
The scream by Terry Freedman

The scream by Terry Freedman, with apologies to E.Munch.

How to retrieve an older version of an Excel spreadsheet

February 8, 2022

Someone we know was in a bit of a panic recently because he had mistakenly deleted part of his Excel spreadsheet, and then saved over it. Was there, he wanted to know, a way of getting back the spreadsheet as it was before he made those ill-advised changes?

As it happens, there often is. Therefore, in case you or one of your colleagues or students experiences a similar mishap, here is a set of instructions that may work. I say “may” because it will depend on factors like which version of Excel you’re using. Also, I don’t know if these will work on a school network. (But if the network administrator is backing up the files every night then he or she may be able to retrieve the older file from the backup.) Nevertheless, it would not be a bad idea to save a copy of your current (incorrect) version before you start, just in case it goes even more wrong.

This is based on the Office 365 version of Excel; I’m not sure if this will work on older versions. If you have an older version, look in the Help for “version history”.

First of all, go to File->Browse Version History, as shown here:

Next, click on Browse Version History. You will see something like this on the screen:

Select a version from before you changed it. You will see that the version is Read Only, and the file you’re working on is unchanged, and the old version has been given a different name:

This message will also appear near the top of the screen:

And in case you need further reassurance, if you look in the Windows menu, you will see the current file and the old version are both open:

I hope you have found this article useful.


If you found this article interesting or useful (or both), why not subscribe to my free newsletter, Digital Education? It’s been going since the year 2000, and has slow news, informed views and honest reviews for Computing and ed tech teachers — and useful experience-based tips.

In Tips for teachers Tags Excel, version history, retrieval
← Quick look: The self-taught computer scientistThe benefits of an open door classrooms policy →
Recent book reviews
Quick looks: VIBE Coding by Example
Quick looks: VIBE Coding by Example

For the time being, this book is free in Kindle format.

Read More →
Review: The Game Changers: How Playing Games Changed the World and Can Change You Too
Review: The Game Changers: How Playing Games Changed the World and Can Change You Too

Despite the relative paucity of immediately obvious National Curriculum links, teachers will find several of sections of this book to be highly engaging.

Read More →
Review: The Dictators: 64 Dictators, 64 Authors, 64 Warnings from History
Review: The Dictators: 64 Dictators, 64 Authors, 64 Warnings from History

In some respects one could view this book as a single warning repeated 64 times.

Read More →
Review: The Bookshop, The Draper, The Candlestick Maker: A History of the High Street 
Review: The Bookshop, The Draper, The Candlestick Maker: A History of the High Street 

Taking readers from the Middle Ages to (more or less) the present day, Gray charts how the places where we do our shopping and what we buy have changed over the centuries.

Read More →
Review: Extraordinary Learning For All
Review: Extraordinary Learning For All

As a source of potential ideas and inspiration, the book could be very useful indeed.

Read More →
Review: Bad Education: Why Our Universities Are Broken and How We Can Fix Them
Review: Bad Education: Why Our Universities Are Broken and How We Can Fix Them

One has the impression that the main role of the university these days is to maximise profit, while that of the majority of teaching staff is to ensure the ‘correct’ views are passed on to students. All the while, students’ main concern seems to be to seek protection from anything that might make them feel unsafe.

Read More →
Review: Next Practices - An Executive Guide for Education Decision Makers
Review: Next Practices - An Executive Guide for Education Decision Makers

Is a 2014 book on managing the computing provision in a school still worth buying?

Read More →
Still relevant (sadly): How to lie with statistics, by Darrell Huff
Still relevant (sadly): How to lie with statistics, by Darrell Huff

Although this book is over 60 years old, it is remarkably apposite for our times -- and especially in the fields of educational research and assessing pupils' understanding and progress.

Read More →
Quick looks: Bad Education: Why Our Universities Are Broken and How We Can Fix Them
Quick looks: Bad Education: Why Our Universities Are Broken and How We Can Fix Them

It was a great source of pride to me, getting hundreds of students through their A levels and encouraging them to go to university. But for some time I have asked myself a question: would I recommend this route now?

Read More →
Review: The Bright Side: Why Optimists Have the Power to Change the World
Review: The Bright Side: Why Optimists Have the Power to Change the World

At first glance, you might take this to be one of those books full of affirmations and anecdotes designed to lift your mood.

Read More →
Dig+Ed+Banner.jpg

Contact us

Privacy

Cookies

Terms and conditions

This website is powered by Squarespace

(c) Terry Freedman All Rights Reserved