MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.


I'm not curious

Spreadsheet Solution – Getting Your Excel File Back

Published on 30 November 16
916
0
0

There’s nothing worse than having your Mac suddenly crash and realizing that you haven’t yet saved your Spreadsheet. After all, in most cases, that means you’ll have to start all over again – and given how meticulous things get when you’re working with numbers and trends, that’s definitely disheartening. If you’re willing to do a bit of sleuthing though, you might just be able to regain what you’ve lost. What should you do exactly to accomplish such a feat? Read on and find out.

Getting into AutoRecovery

There’s a chance that Excel itself managed to save the file before the crash completely halted your computer. If that’s the case, you only have to open the program once again and check whether copies of your work have been made. Do take note that these might not be as updated as you’d like, given that their recentness depends on the AutoRecovery’s interval. With that said, after you’ve made sure that you didn’t lose everything you’ve done so far, you might want to tinker with Excel’s options and set a shorter interval.


By the way, if you really want to make sure that you’re not going to start from scratch, it’s best to immediately save a copy of the recovered spreadsheet. Closing the software right after checking what AutoRecovery has managed to do, essentially means that you haven’t seen anything of value – in other words, the software immediately deletes those files and you’ll really have to work right from the beginning. Once again, do not forget to save (through the Save As function, of course).

Prepare for the Next Case

Managing to get your files back for now doesn’t mean you won’t be facing a similar problem in the future. Likewise, there’s no guarantee that you’ll always have a lot of time for troubleshooting. That’s why you have to make sure that you’re sufficiently prepared for another crash. Well, one thing you could do to make the search easier next time around is to set another location for your AutoRecovery backups. Begin by going to Excel’s Preferences menu and going to the Personal Settings screen. From there, find AutoRecover Files in the list and click Modify.

You’ll be given the option to choose another folder in which copies of your work will be sent. For most people, the best choice here is to set the Desktop as the directory of choice. Why’s that? It is much more accessible than Microsoft Office’s often-hidden system folders, meaning there won’t be much suspense after restarting your Mac – it wouldn’t even be necessary to worry about your spreadsheet while waiting for the program to load, given that you’ll get to find out your fate with just a glance.


Spreadsheet Solution – Getting Your Excel File Back - Image 1Consider Another Possibility

Lost progress (or losing entire files) isn’t always due to crashes. Sometimes, they’re the outcome of a sudden power loss. If you’re beginning to doubt your area’s power supply, you might want to consider investing in a reliable battery backup. Such a device doesn’t really cost much, but it’s potential in saving you from future headaches is arguably unparalleled. By the way, do keep in mind that battery backups are only capable of providing several minutes of extended use – so once the power cuts, quickly save your work.

On Making the Right Choices

As you should have realized by now, it isn’t enough to just have the necessary knowledge in file recovery. You will also have to rely on your drive for preparedness in staying one step ahead of the problem. Simply put, the more thought you put into keeping your files protected from crashes, outages, or any other issues, the more likely you’ll dodge the most common Excel dilemmas.



There’s nothing worse than having your Mac suddenly crash and realizing that you haven’t yet saved your Spreadsheet. After all, in most cases, that means you’ll have to start all over again – and given how meticulous things get when you’re working with numbers and trends, that’s definitely disheartening. If you’re willing to do a bit of sleuthing though, you might just be able to regain what you’ve lost. What should you do exactly to accomplish such a feat? Read on and find out.

Getting into AutoRecovery

There’s a chance that Excel itself managed to save the file before the crash completely halted your computer. If that’s the case, you only have to open the program once again and check whether copies of your work have been made. Do take note that these might not be as updated as you’d like, given that their recentness depends on the AutoRecovery’s interval. With that said, after you’ve made sure that you didn’t lose everything you’ve done so far, you might want to tinker with Excel’s options and set a shorter interval.

By the way, if you really want to make sure that you’re not going to start from scratch, it’s best to immediately save a copy of the recovered spreadsheet. Closing the software right after checking what AutoRecovery has managed to do, essentially means that you haven’t seen anything of value – in other words, the software immediately deletes those files and you’ll really have to work right from the beginning. Once again, do not forget to save (through the Save As function, of course).

Prepare for the Next Case

Managing to get your files back for now doesn’t mean you won’t be facing a similar problem in the future. Likewise, there’s no guarantee that you’ll always have a lot of time for troubleshooting. That’s why you have to make sure that you’re sufficiently prepared for another crash. Well, one thing you could do to make the search easier next time around is to set another location for your AutoRecovery backups. Begin by going to Excel’s Preferences menu and going to the Personal Settings screen. From there, find AutoRecover Files in the list and click Modify.

You’ll be given the option to choose another folder in which copies of your work will be sent. For most people, the best choice here is to set the Desktop as the directory of choice. Why’s that? It is much more accessible than Microsoft Office’s often-hidden system folders, meaning there won’t be much suspense after restarting your Mac – it wouldn’t even be necessary to worry about your spreadsheet while waiting for the program to load, given that you’ll get to find out your fate with just a glance.

Spreadsheet Solution – Getting Your Excel File Back - Image 1
Consider Another Possibility


Lost progress (or losing entire files) isn’t always due to crashes. Sometimes, they’re the outcome of a sudden power loss. If you’re beginning to doubt your area’s power supply, you might want to consider investing in a reliable battery backup. Such a device doesn’t really cost much, but it’s potential in saving you from future headaches is arguably unparalleled. By the way, do keep in mind that battery backups are only capable of providing several minutes of extended use – so once the power cuts, quickly save your work.

On Making the Right Choices

As you should have realized by now, it isn’t enough to just have the necessary knowledge in file recovery. You will also have to rely on your drive for preparedness in staying one step ahead of the problem. Simply put, the more thought you put into keeping your files protected from crashes, outages, or any other issues, the more likely you’ll dodge the most common Excel dilemmas.

This review is listed under Data & Information Management Community

Related Posts:
Post a Comment

Please notify me the replies via email.

Important:
  • We hope the conversations that take place on MyTechLogy.com will be constructive and thought-provoking.
  • To ensure the quality of the discussion, our moderators may review/edit the comments for clarity and relevance.
  • Comments that are promotional, mean-spirited, or off-topic may be deleted per the moderators' judgment.
You may also be interested in
Awards & Accolades for MyTechLogy
Winner of
REDHERRING
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top