{"id":266800,"date":"2024-03-13T20:09:00","date_gmt":"2024-03-13T19:09:00","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=266800"},"modified":"2026-11-12T14:26:58","modified_gmt":"2026-11-12T13:26:58","slug":"recuperar-arquivos-excel-nao-salvos","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/excel-features\/how-to-recover-unsaved-excel-file\/","title":{"rendered":"Como recuperar arquivos do Excel n\u00e3o salvos"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>One of the most common situations when working with various Excel files simultaneously is forgetting to save them and then spending too much time trying to recover them. In some cases, this can lead to a never-ending frustration, something that can easily be avoided in a few simple steps.<\/p>\n<p>Depending on your operating system, the recovery steps will be different. However, Excel offers a built-in \u201cAutoSave\u201d and &#8220;AutoRecover&#8221; feature that will work on both Windows and Mac. You simply need to make sure that it is enabled before beginning the recovery process.<\/p>\n<p>In this article, we\u2019ll explain how to recover unsaved Excel files that you never saved, how to retrieve an unsaved version, and how to recover a saved-over Excel file. Although the recovery process is straightforward, we will also walk you through the basic precautions to avoid having to resort to recovering Excel files altogether.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-recover-an-unsaved-excel-file&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to recover an unsaved Excel file<\/h2>\n<p>Before going into the steps on how to recover unsaved Excel files, let\u2019s explain the three most common scenarios where you would need to recover an Excel file.<\/p>\n<p><strong>1.<\/strong> Your computer or Excel crashes, and you hadn\u2019t saved the file you were working on.<\/p>\n<p><strong>2.<\/strong> Your computer or Excel crashes, and you didn\u2019t save the changes made to your file.<\/p>\n<p><strong>3.<\/strong> You saved changes made to your file but want to retrieve a previous version.<\/p>\n<p>These three scenarios can be avoided altogether by making sure that the \u201cAutoSave\u201d and &#8220;AutoRecover&#8221; feature in Excel is enabled. You can use the following four methods to also avoid these scenarios from happening again:<\/p>\n<ul>\n<li><strong>Upload Excel file to OneDrive:<\/strong> If several users are working on the same file, the best way to keep them safe is to work online. In OneDrive, you can easily retrieve a previous version by right-clicking the file and selecting &#8220;Version history&#8221;. Click on the version you want to restore or download.<\/li>\n<li><strong>Upload Excel file to <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/connect-dropbox-spreadsheets-automatically\/\">Dropbox<\/a>:<\/strong> This platform is an alternative to OneDrive and allows for an easy recovery of a previous version. In this case, you need to click on the three dots next to the target file to check the previous versions. Once you identify the version to restore, click on it.<\/li>\n<li><strong>Enable &#8220;AutoSave&#8221; and &#8220;AutoRecover&#8221;:<\/strong> If you prefer working on the Excel app or desktop version, make sure that these features are enabled. Although they should be enabled by default, it may not be the case. AutoSave is the toggle at the top left of the Excel window, and it works for files stored in OneDrive or SharePoint. For AutoRecover, go to File &gt; Options &gt; Save and check that &#8220;Save AutoRecover information every X minutes&#8221; and &#8220;Keep the last AutoRecovered version if I close without saving&#8221; are both activated. The same page shows the &#8220;AutoRecover file location&#8221;.<\/li>\n<li><strong>Auto-backup Excel files:<\/strong> You can use the backup file to retrieve any saved-over version of your Excel file. Go to File &gt; Save As &gt; Browse, and in the &#8220;Save As&#8221; dialog box, select &#8220;Tools&#8221; &gt; &#8220;General Options&#8221;. Then check &#8220;Always create backup&#8221;.<\/li>\n<\/ul>\n<p>Now that we know the types of scenarios that could lead to losing data and the precautions to take to avoid it, let\u2019s see how we can recover an Excel file that you never saved.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-recover-an-excel-file-that-was-ne&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to recover an Excel file that was never saved<\/h2>\n<p>This recovery method applies to the first scenario, in which you never saved the Excel file you were working on. You\u2019ll now learn how to recover an Excel file that was never saved. You simply need to \u200cenable the built-in \u201cAutoSave\u201d and &#8220;AutoRecover&#8221; functionality in Excel.<\/p>\n<p><strong>1.<\/strong> Open a new Excel workbook. Go to File &gt; Open &gt; Recent.<\/p>\n<p><strong>2.<\/strong> Select &#8220;Recover Unsaved Workbooks&#8221; at the bottom of the list. You can also find it under File &gt; Info &gt; Manage Workbook.<\/p>\n<p><strong>3.<\/strong> Browse through the unsaved Excel files and open the one you want to recover.<\/p>\n<p><strong>4.<\/strong> To save, choose the \u201cSave As\u201d using a different name and check that the location of the file is the one you want.<\/p>\n<p>These steps will work on any Excel file in Windows 10 or later, and in Microsoft 365. If you have issues finding the unsaved Excel files following the previous method, it\u2019s useful to know where Excel stores unsaved files by default.<\/p>\n<h3>Where are unsaved Excel files stored?<\/h3>\n<p>Excel saves a copy of all unsaved files by default in the following locations, depending on your operating system:<\/p>\n<ul>\n<li><strong>Windows 10 (onwards):<\/strong> C:&#92;Users&#92;[YourSystemName]&#92;AppData&#92;Local&#92;Microsoft&#92;Office&#92;UnsavedFiles<\/li>\n<\/ul>\n<ul>\n<li><strong>Mac (head to Finder &gt; Go &gt; Go to Folder\u2026 and enter the following):<\/strong> \/Users\/&lt;username&gt;\/Library\/Containers\/com.microsoft.Excel\/Data\/Library\/Preferences\/AutoRecovery<\/li>\n<\/ul>\n<p>Simply replace &#8220;[YourSystemName]&#8221; (Windows) or &#8220;&lt;username&gt;&#8221; (Mac) with your user name. Your unsaved files should appear, ready for you to recover and save.<\/p>\n<p>All unsaved Excel files are stored using a special format, so make sure that you save them in the format of your choice. Let\u2019s now see how to recover your file based on the second scenario we outlined before.<\/p>\n<h3>How to recover an Excel file that was only saved once<\/h3>\n<p>This second method applies to any case where you didn\u2019t save the latest version of your Excel file. This is how you can recover the updated version of an Excel file.<\/p>\n<p><strong>1.<\/strong> Open Excel and click on any of the files listed in the &#8220;Document Recovery&#8221; pane.<\/p>\n<p><strong>2.<\/strong> Save the file with a different name.<\/p>\n<p>If you use the Excel application, you can directly click on \u201cShow Recovered Files\u201d which will take you to the same &#8220;Document Recovery&#8221; pane. Let\u2019s now see how to recover a previous version of an Excel file.<\/p>\n<h3>How to recover an Excel file that was saved over<\/h3>\n<p>This third recovery method applies to the scenario where you saved changes made to your file but want to retrieve a previous version.<\/p>\n<p><strong>1.<\/strong> Go to File &gt; Info &gt; Version History. If the file is not stored in OneDrive or SharePoint, look for the autosaved versions listed under File &gt; Info &gt; Manage Workbook instead.<\/p>\n<p><strong>2.<\/strong> Select the version you would like to restore and open it.<\/p>\n<p><strong>3.<\/strong> Click \u201cRestore\u201d to retrieve the previous version using the same name, or click on \u201cSave as\u201d to use a different name.<\/p>\n<p>Don\u2019t forget that in order for this last method to work, you need to enable the \u201cAutoRecover\u201d feature. Accessing previous versions of your Excel file will be easier if you work on OneDrive since most cloud environments keep previous versions by default. Google Sheets keeps a version history too, so if you are weighing a move, read our <a href=\"https:\/\/www.sheetgo.com\/blog\/spreadsheets-tips\/google-sheets-vs-microsoft-excel\/\">Google Sheets vs Microsoft Excel comparison<\/a>.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>Losing an Excel file can be an extremely stressful situation, and it\u2019s easy to forget the basic methods Excel offers to help you find and restore your files. You should now understand the easy methods that will allow you to quickly recover unsaved or saved-over Excel files. Simply remember to always have the \u201cAutoSave\u201d and &#8220;AutoRecover&#8221; Excel feature enabled, which can help you recover unsaved Excel files in Windows 10 or Mac operating systems, as well as in Microsoft 365.<\/p>\n<p>Although recovery is always possible, we strongly recommend taking the four precautions we outlined, especially if you are collaborating on the Excel file. If you would like to know how to upload your file for collaboration, read our blog article <a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/how-to-share-excel-file\/\">How To Share An Excel File<\/a>.<\/p>\n<p>Recovery is also easier when fewer copies of a file get edited by hand. If you move data between Excel workbooks by copying and pasting, <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo&#8217;s AI automations<\/a> can connect those files in OneDrive and update them on a schedule. Our guides on <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/merging-excel-files\/\">merging multiple Excel files into one<\/a> and <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/consolidate-excel-files-automatically\/\">consolidating Excel files automatically<\/a> show how it works.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>O Excel fechou antes de voc\u00ea salvar? Veja como recuperar os dados de um arquivo do Excel n\u00e3o salvo com AutoRecupera\u00e7\u00e3o, Recupera\u00e7\u00e3o de Documentos e Hist\u00f3rico de Vers\u00f5es.<\/p>","protected":false},"author":2,"featured_media":266801,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-266800","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/266800","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=266800"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/266800\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/266801"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=266800"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=266800"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=266800"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}