How to Recover a Prior Version of an Excel File - Tutorial
See, step-by-step, how you can recover a prior version of an Excel file. If you've ever opened a spreadsheet only to discover it's been changed since you were last in it, you can probably relate to the type of panic this causes.
Or maybe your last update had wrong data. It can happen to the best of us...
Good news! - newer versions of Excel keep a history of some of your past saves.
In this Excel tutorial, you'll see how you can access these prior versions. This means that you can open any of your prior saves, review them, and decide which one you'd like to use.
Once you've decided which version of your sheet you need, you can either save it as a new file (with a new file name) or replace the most current file with it.
I used Microsoft 365 for Windows in creating this tutorial. In other versions of Excel, the labels you'll look for to recover other versions of your workbook may be a little different. For example, if you're using:
-Excel 2010 and 2013 users, go to File, Info, then Manage Versions
-Excel 2016 or 2019, go to File, then History
-Mac users go to File, then Browse Version History
Click here to read our step-by-step article on this: yacostasolutions.com/recover-...
If you liked this, make sure to get your FREE pdf list of top Excel keyboard shortcuts: yacostasolutions.com/newsletter/
*FYI:
This tutorial was created using the desktop version of Excel in Microsoft 365. You can upgrade to this version here: yacostasolutions.com/MS365
The screen recording + editing was done using Techsmith Camtasia. You can check it out here: yacostasolutions.com/camtasia
Thanks for watching this Microsoft Excel tutorial and, don’t forget, if you like this video, please “Like” and “Share” with your friends - it really helps us out 😊
To catch our Excel tutorials as they come out, subscribe to this channel by clicking: yacostasolutions.com/youtube
Thanks!
*DISCLAIMER: This video description contains affiliate links, which means that if you click on one of the product links, I’ll receive a small commission. As an Amazon Associate I earn from qualifying purchases. This helps support the channel and allows us to continue to make tutorials like this. Thank you for your support!
#YAcostaTutorials
Пікірлер: 99
But there is nothing on version history. Can restore only the unsaved file but cannot find previous version file of other excel file
OMG this video was such a life saver today! Thank you so much for posting a short, simple, and concise tutorial!!!!
@YAcostaSolutions
3 ай бұрын
That’s great! I’m so happy this helped you, Valentino. Thanks so much for letting me know 🙂
Thank you! I watched other videos on solutions and none of them worked. I used yours and had the document back in 30 seconds. Great!
@YAcostaSolutions
Жыл бұрын
That must've been a relief! I'm so glad this helped you, Peter🙂
You're doing the lords work, I love u
@YAcostaSolutions
16 күн бұрын
What generous feedback! Thank you so much 🙂
This happened to me today and I am so happy I found this info, You are a life saver !
@YAcostaSolutions
4 ай бұрын
Oh wow! I'm so happy this helped you out, Jeff. Thanks so much for the comment 🙂
This has happened to me on several occasions. Now I know what to do! Thanks!
@YAcostaSolutions
Жыл бұрын
That’s great, Roger! So happy this was useful for you 🙂
Thank you very much. It's workable. You solved my problem.
@YAcostaSolutions
16 күн бұрын
That's great, Gomathi! I'm glad this was able to help you 🙂
Absolutely saved my life today, thanks so much for this
@YAcostaSolutions
6 ай бұрын
So happy this helped you! Thanks so much 🙂
Thank you Acosta.... The video was very helpful to me to serve the purpose 🙂
@YAcostaSolutions
Жыл бұрын
That's great, Navneet! I'm so happy this helped you 🙂
You deserve an award thank you so much!!
@YAcostaSolutions
6 ай бұрын
Oh wow! Thank you so much! I'm happy you found this so helpful 🙂
this was very helpful. thanks soooo much 🥰
@YAcostaSolutions
Жыл бұрын
You're so very welcome! I'm glad this helped you 🙂
thanks for the info it was helpful. you have make my day!
@YAcostaSolutions
Жыл бұрын
That's great, Emmanuel! I'm so happy this was a big help to you 🙂
Thank You so much, you are a life saver!!!!
Hello, Thank you very much for your help. You are my savior for today. Thanks a ton!
@YAcostaSolutions
3 ай бұрын
Oh wow! I’m so happy this was so helpful for you! Thanks so much 🙂
Lady I owe you my life ❤
@YAcostaSolutions
3 ай бұрын
Thanks, Ditiro! I’m happy this was so helpful for you 🙂
Helpful video Thank you❤️
@YAcostaSolutions
Жыл бұрын
Thanks so much! I'm happy you found this helpful 🙂
You have just save my day .. thanks
@YAcostaSolutions
Жыл бұрын
Yay! That's great! So happy this was helpful for you, Joshua 🙂
Hi Acosta, you are awesome, you made my day, great tutoriol.
@YAcostaSolutions
16 күн бұрын
I'm happy this helped you, Magdi. Thanks so much 🙂
works like magic! you saved my life!
@YAcostaSolutions
16 күн бұрын
Awesome! I'm so happy this helped you 🙂
Thankyou,it's very helpful
@YAcostaSolutions
Жыл бұрын
Thank you! I'm so glad you liked this 🙂
I can't see a 'Restore Previous Version' option when I click the "Info" tab. It doesn't come up when I right click on the document either. What am I missing? 😟
Thank you so much for the tip.
@YAcostaSolutions
Жыл бұрын
You're very welcome! I'm glad you liked this 🙂
Thank you!!! your video saved me today!
@YAcostaSolutions
3 ай бұрын
I’m so happy this helped you, Annitta! Thanks so much 🙂
You are a life saver!!!😊
@YAcostaSolutions
4 ай бұрын
Oh wow! I’m so happy this helped you out so much, Rahul. Thanks so much for watching and commenting 🙂
Thank you so much Acosta :)
@YAcostaSolutions
11 ай бұрын
Thank you, Sachin! So glad this helped you 🙂
Thank you!!
@YAcostaSolutions
Жыл бұрын
Thank you! So happy you liked this 🙂
Thank you so much ❤
@YAcostaSolutions
4 ай бұрын
I'm so happy this helped you! Thanks 🙂
Thank you!!!
@YAcostaSolutions
3 ай бұрын
Thanks, Eddy! I’m so happy you liked this 🙂
you kinda saved my life akkaaa
@YAcostaSolutions
10 ай бұрын
Awesome! So glad that this tutorial helped you out 🙂
Thank you very much
@YAcostaSolutions
5 ай бұрын
Thank you! I’m happy you liked this 🙂
Praise the LORD!!! you were a life saver!
@YAcostaSolutions
4 ай бұрын
You're so welcome, Christi! I'm happy this helped you 🙂
You saved my ass, thanks
@YAcostaSolutions
4 сағат бұрын
So happy this helped you, Douglas! Thanks so much 🙂
Thank you
@YAcostaSolutions
Жыл бұрын
Thanks, Junaid! I'm happy you liked this 🙂
Thank You Acosta
@YAcostaSolutions
10 ай бұрын
I’m so glad this helped you! Thanks for watching + commenting 🙂
I just happened to come across your channel. Could you share with how to create a match n index with one formula
thank you
@YAcostaSolutions
9 ай бұрын
You're very welcome, Walid. I'm glad this was helpful for you 🙂
Life savor!!!!!
@YAcostaSolutions
11 ай бұрын
I'm so happy this was helpful for you, Kirsten. Thanks so much 🙂
For some reason I couldn't see the "version History" when clicking on the 'file' tab then 'info'. I was so confused and then I thought about right clicking on the document itself and so a "Restore previous versions" button and could see indeed the previous versions. BTW I'm using Excel 2016.
@YAcostaSolutions
11 ай бұрын
That's great! I'm so happy you were able to find the solution. Thanks so much for sharing about it. You've probably helped a good number of people out of a crisis 🙂 Thanks so much!
This doesn't even work if you don't have them files been constantly uploading on onedrive.
This was very helpful. But I wonder why only a June 2023 file was offered for recovery. Don't get me wrong, that was very helpful, but it would have been less painful had a more recent version been presented for recovery. Thanks again for you help
@YAcostaSolutions
6 ай бұрын
Ugh! That sucks, James! It could be that, somewhere along the way, the "Autosave" button was toggled off 🤷♀️ I'm sorry this wasn't able to help you better, but I really appreciate you watching and commenting. Thanks for that 🙂
Thanks
@YAcostaSolutions
2 ай бұрын
Thanks, Vidya! I’m so happy you liked this 🙂
I LOVE YOUUUUUUU
@YAcostaSolutions
16 күн бұрын
Awww thanks! I'm happy you liked this 🙂
THANK YOOOOU!!!!
@YAcostaSolutions
5 ай бұрын
Thanks so much! I’m so glad you liked this 🙂
There is no any option showing about version history in info section... what can I do?
how to recover a file 2 days BEFORE any changes made? I can only see the current and today changes. huhu
I dont have 'infox on my excel. Its replaced by 'add ins'. Is this a version error?
Browse version history is grayed out on MAC - How can I recover it?
i have excel file name Contracts-GC.xls with many version history from Januart 2023 to May 2023 now i save another file name Contracts-GC-June29.xls, but all original version history gone form my original file name Contracts-GC.xls, how to see again all verion history of Contracts-GC.xls again
@harshapriya8278
5 ай бұрын
Have u restored the old file. Now I need help for this
This option is not available in excel 2016
I am not seeing file on my computer it start at home 😢
Is this a 2010 are 2007 version excel cause am not seeing file
when i open ‘info’ there is no version history written
M using 2010 not getting older version
Hi i need help
version history not showing on excel 2016
@YAcostaSolutions
Жыл бұрын
Hi. Thanks for your question. Can you double check to see if you have an Info tab? From your Excel ribbon, click the File tab. The Info tab would be here if you have it.
@Nandakumar-ye5tb
Жыл бұрын
its not showing on my excel 2016 too
Hi need help
Hola soy corneyo
@YAcostaSolutions
11 ай бұрын
Hi 👋