Go to File > Info > Manage Document > Recover Unsaved Workbooks in Excel, or Recover Unsaved Presentations in PowerPoint.
Pogledajte cijeli odgovor
Contents
How to recover Excel files that are not saved?
Recover an Excel File with Unsaved Changes – If you were making changes to an Excel file and didn’t have the chance to save them before having to shut down the program, you’ll need another way to recover an Excel file that was not saved. Once everything is working properly again, open up Excel.
Pogledajte cijeli odgovor
How do I recover a deleted Excel file on a Mac?
Download Article Easy ways to recover a corrupt Excel file Download Article This wikiHow teaches you how to recover and repair a corrupted Microsoft Excel file on your Windows or Mac computer.
- 1 Make sure that you’re using a Windows computer. You can only repair an Excel file in the Windows version of Excel.
- If you’re using a Mac, try one of the other methods in this article.
- 2 Open Excel. Its app icon resembles a green box with a white “X” on it. Advertisement
- 3 Click Open Other Workbooks, This option is next to a folder-shaped icon in the lower-left corner of the window.
- 4 Click Browse, It’s a folder-shaped icon in the middle of the page. Doing so opens a File Explorer window.
- 5 Select your Excel file. Go to the folder in which your corrupted Excel file is stored, then click the Excel file to select it.
- 6 Click the “Menu” icon, It’s the downward-facing arrow to the right of the Open button. A drop-down menu will appear.
- 7 Click Open and Repair, This option is at the bottom of the drop-down menu.
- If Open and Repair. is greyed out, make sure that your Excel file is selected and try again. If it’s still greyed out, you can’t repair this file.
- 8 Click Repair when prompted. It’s in a pop-up window. Windows will begin attempting to repair your file.
- If you don’t have this option, click Extract Data instead, then click either Convert to Values or Recover Formulas, This will recover any salvageable data.
- 9 Wait for the file to open. This may take a few minutes if your Excel file is large.
- If the file still won’t open, go back through this process and click Extract Data instead of Repair when prompted.
- 10 Save your file. Once the repaired file opens, press Ctrl + S, double-click This PC, select a save location, enter a file name, and click Save,
- Be sure to select a different file name than the one which you used for the corrupted Excel file.
Advertisement
- 1 Understand why the file type matters. Sometimes, Excel documents created on older computers or versions of Excel become unstable on newer versions; similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to “xlsx” (or “xls” for older programs), you can fix this problem.
- 2 Open Start, Click the Windows logo in the bottom-left corner of the screen.
- 3 Open File Explorer, Click the folder-shaped icon in the lower-left side of the Start window.
- 4 Click the View tab. It’s at the top of the File Explorer window. A toolbar will appear below this tab.
- 5 Check the “File name extensions” box. This option is in the “Show/hide” section of the toolbar. Doing so will allow you to see the file type extensions at the end of files, including your Excel document.
- 6 Select your Excel file. Go to the location of the Excel document that you want to recover, then click the document to select it.
- 7 Click Home, It’s a tab in the upper-left side of the File Explorer window. This will prompt a toolbar to appear.
- 8 Click Rename, This option is in the “Organize” section of the toolbar. Clicking Rename will cause the Excel file’s name to become highlighted.
- 9 Change the file type. Replace whatever comes after the period at the end of the file name with xlsx and then press ↵ Enter,
- For example, if the document was named “Spreadsheet1.docx”, you would change it to “Spreadsheet1.xlsx”.
- If the file extension already is “xlsx”, try using “xls” or “html”.
- 10 Click Yes when prompted. This will confirm your changes and change the file extension.
- 11 Try opening the file. Double-click the file to open it. If the file opens in Excel (or, if you selected “html” as the extension, a web browser), your file has successfully been recovered.
- If you chose the “html” extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new “xlsx” file.
- If the file still won’t open, proceed to the next Windows method,
Advertisement
- 1 Understand why the file type matters. Sometimes, Excel documents created on older computers or versions of Excel become unstable on newer versions; similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to “xlsx” (or “xls” for older programs), you can fix this problem.
- 2 Open Finder. Click the blue, face-shaped app icon in your Mac’s Dock.
- 3 Select the Excel file. Go to the folder in which your Excel file is located, then click the Excel file that you want to recover.
- 4 Click File, This menu item is in the top-left corner of your Mac’s screen. Clicking it prompts a drop-down menu.
- 5 Click Get Info, It’s in the File drop-down menu. This will open a pop-up window.
- 6 Expand the “Name & Extension” section if necessary. If you don’t see any file name or extension below this category, click the triangle to the left of the “Name & Extension” heading to view the file’s name and extension.
- 7 Change the file type. Replace whatever comes after the period at the end of the file name with xlsx and then press ⏎ Return,
- For example, if the document was named “Spreadsheet1.txt”, you would change it to “Spreadsheet1.xlsx”.
- If the file extension already is “xlsx”, try using “xls” or “html”.
- 8 Click Use,xlsx when prompted. This will confirm your decision and change the file type.
- 9 Try opening the file. Double-click the file to open it. If the file opens in Excel (or, if you selected “html” as the extension, a web browser), your file has successfully been recovered.
- If you chose the “html” extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new “xlsx” file.
- If the file still won’t open, proceed to the next Mac method,
Advertisement
- 1 Understand the limitations of this method. Like most Microsoft Office products, Excel will automatically save recovery versions of files, meaning that you may be able to restore a partial version of your corrupted Excel document. However, Excel doesn’t always save these files in time, and you most likely won’t be able to recover the whole document in this way.
- 2 Open Start, Click the Windows logo in the bottom-left corner of the screen.
- 3 Type in this pc, This will search your computer for the “This PC” program.
- 4 Click This PC, It’s the computer monitor-shaped icon at the top of the Start window. Doing so opens the This PC window.
- 5 Double-click your computer’s hard drive. This is usually the “OS (C:)” option below the “Devices and drives” heading in the middle of the page.
- 6 Double-click the “Users” folder. You’ll find this in the middle of the hard drive’s folder.
- 7 Double-click your user folder. This folder is labeled with part or all of your username on your computer.
- 8 Double-click the “AppData” folder. It’s in the “A” section, so you’ll most likely find this folder near the top of the window.
- If you can’t find this folder, click the View tab, then check the “Hidden items” box in the “Show/hide” section to prompt the “AppData” folder to appear.
- 9 Double-click the “Local” folder. This option is near the top of the folder.
- 10 Scroll down and double-click the “Microsoft” folder. You’ll find it in the “M” section.
- 11 Double-click the “Office” folder. It’s in the “O” section of the Microsoft folder.
- 12 Double-click the “UnsavedFiles” folder. This folder should be near the top of the window.
- 13 Select an Excel file. Look for an Excel file icon that has a name matching your corrupted Excel file, then click it to select it.
- If you don’t see any files here, a recovery version of your Excel document was not saved.
- 14 Change the Excel file’s extension. To do so:
- Click View
- Check the “File name extensions” box.
- Click Home
- Click Rename
- Replace the,tmp section with,xlsx
- Press ↵ Enter,
- Click Yes when prompted.
- 15 Open the Excel file. Double-click the file that you just renamed to open it.
- 16 Save your file. Once the restored file opens, press Ctrl + S, double-click This PC, select a save location, enter a file name, and click Save,
- Be sure to select a different file name than the one which you used for the corrupted Excel file.
Advertisement
- 1 Understand the limitations of this method. Like most Microsoft Office products, Excel will automatically save recovery versions of files, meaning that you may be able to restore a partial version of your corrupted Excel document. However, Excel doesn’t always save these files in time, and you most likely won’t be able to recover the whole document in this way.
- 2 Click Go, This menu item is at the top of the screen. Clicking it prompts a drop-down menu.
- If you don’t see the Go menu item, first open Finder or click the desktop to make it appear.
- 3 Hold down the ⌥ Option key. After doing this, you should see the Library folder appear in the Go drop-down menu.
- 4 Click Library, It’s in the Go drop-down menu. This will open the Library hidden folder.
- 5 Open the “Containers” folder. Double-click the “Containers” folder, which is in the “C” section of the Library folder.
- 6 Click the search bar. It’s in the upper-right side of the window.
- 7 Search for the Microsoft Excel folder. Type in com.microsoft.Excel and press ⏎ Return,
- 8 Click the Containers tab. You’ll find this to the right of the “Search:” heading near the top of the Finder window.
- 9 Open the “com.microsoft.Excel” folder. Double-click this folder to open it.
- 10 Open the “Data” folder.
- 11 Open the “Library” folder.
- 12 Open the “Preferences” folder. If you don’t see this folder, scroll down to find it.
- 13 Open the “AutoRecovery” folder. This will bring up a list of automatically saved versions of your Excel files.
- 14 Find a temporary version of your Excel file. The temporary version of your Excel file should have some or all of the file’s name in its title.
- If you can’t find the temporary version of your Excel file, it wasn’t backed up.
- 15 Select the Excel file. Click the Excel file to do so.
- 16 Click File, It’s a menu item in the upper-left corner of your Mac’s screen. A drop-down menu will appear.
- 17 Select Open With, This option is near the top of the File drop-down menu. You should see a pop-out menu open.
- 18 Click Excel, It’s in the pop-out menu. Doing so will prompt the temporary version of the Excel document to open in Excel.
- The temporary version will probably not include some of your most recent changes to the original Excel document.
- 19 Save the document. Press ⌘ Command + S, then enter a file name, select a save location in the “Where” menu, and click Save,
Advertisement
Add New Question
- Question I cannot open the file with my Excel file, but I can open it in another computer. Why? It’s likely that the other computer has either an older or newer version of Excel, and your document is not compatible with the version you have on your computer.
- Question What do I do if my Excel files are save with the extension xls? Nakamura Rei Community Answer You can repair,xls files using methods from this article as well as xlsx.
- Question How do I recover a deleted excel file in Windows 7? y\You can use the same method. However, to change the file extension you will need to use CMD and run a command like this (make sure you are in the right directory): rename (corrupted excel file, add its file extension at the end) (corrupted excel filename, do NOT add the file extension at the end).(xls, xlsx).
Ask a Question 200 characters left Include your email address to get a message when this question is answered. Submit Advertisement
- Windows computers will often attempt to repair automatically the corrupted Excel workbook when you open it.
- You may be able to open an otherwise corrupted Excel file by placing your computer in safe mode, If so, a file error or a virus is most likely the reason for your document failing to open.
- There are a few paid data recovery software options that you can use to recover corrupted Excel files. Stellar Phoenix Excel Repair, which is available for both Windows and Mac computers, is a good example of such a program.
Thanks for submitting a tip for review! Advertisement
Unfortunately, some Excel files may be entirely unrecoverable.
Advertisement Article Summary X 1. Open Excel.2. Select Open Other Workbooks,3. Select the corrupted file.4. Click the down-arrow menu next to “Open.” 5. Select Open and Repair,6. Click Repair,7. Click Close when complete. Did this summary help you? Thanks to all authors for creating a page that has been read 1,333,549 times.
Pogledajte cijeli odgovor
How do I recover an HTML file in Excel?
Download Article Easy ways to recover a corrupt Excel file Download Article This wikiHow teaches you how to recover and repair a corrupted Microsoft Excel file on your Windows or Mac computer.
- 1 Make sure that you’re using a Windows computer. You can only repair an Excel file in the Windows version of Excel.
- If you’re using a Mac, try one of the other methods in this article.
- 2 Open Excel. Its app icon resembles a green box with a white “X” on it. Advertisement
- 3 Click Open Other Workbooks, This option is next to a folder-shaped icon in the lower-left corner of the window.
- 4 Click Browse, It’s a folder-shaped icon in the middle of the page. Doing so opens a File Explorer window.
- 5 Select your Excel file. Go to the folder in which your corrupted Excel file is stored, then click the Excel file to select it.
- 6 Click the “Menu” icon, It’s the downward-facing arrow to the right of the Open button. A drop-down menu will appear.
- 7 Click Open and Repair, This option is at the bottom of the drop-down menu.
- If Open and Repair. is greyed out, make sure that your Excel file is selected and try again. If it’s still greyed out, you can’t repair this file.
- 8 Click Repair when prompted. It’s in a pop-up window. Windows will begin attempting to repair your file.
- If you don’t have this option, click Extract Data instead, then click either Convert to Values or Recover Formulas, This will recover any salvageable data.
- 9 Wait for the file to open. This may take a few minutes if your Excel file is large.
- If the file still won’t open, go back through this process and click Extract Data instead of Repair when prompted.
- 10 Save your file. Once the repaired file opens, press Ctrl + S, double-click This PC, select a save location, enter a file name, and click Save,
- Be sure to select a different file name than the one which you used for the corrupted Excel file.
Advertisement
- 1 Understand why the file type matters. Sometimes, Excel documents created on older computers or versions of Excel become unstable on newer versions; similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to “xlsx” (or “xls” for older programs), you can fix this problem.
- 2 Open Start, Click the Windows logo in the bottom-left corner of the screen.
- 3 Open File Explorer, Click the folder-shaped icon in the lower-left side of the Start window.
- 4 Click the View tab. It’s at the top of the File Explorer window. A toolbar will appear below this tab.
- 5 Check the “File name extensions” box. This option is in the “Show/hide” section of the toolbar. Doing so will allow you to see the file type extensions at the end of files, including your Excel document.
- 6 Select your Excel file. Go to the location of the Excel document that you want to recover, then click the document to select it.
- 7 Click Home, It’s a tab in the upper-left side of the File Explorer window. This will prompt a toolbar to appear.
- 8 Click Rename, This option is in the “Organize” section of the toolbar. Clicking Rename will cause the Excel file’s name to become highlighted.
- 9 Change the file type. Replace whatever comes after the period at the end of the file name with xlsx and then press ↵ Enter,
- For example, if the document was named “Spreadsheet1.docx”, you would change it to “Spreadsheet1.xlsx”.
- If the file extension already is “xlsx”, try using “xls” or “html”.
- 10 Click Yes when prompted. This will confirm your changes and change the file extension.
- 11 Try opening the file. Double-click the file to open it. If the file opens in Excel (or, if you selected “html” as the extension, a web browser), your file has successfully been recovered.
- If you chose the “html” extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new “xlsx” file.
- If the file still won’t open, proceed to the next Windows method,
Advertisement
- 1 Understand why the file type matters. Sometimes, Excel documents created on older computers or versions of Excel become unstable on newer versions; similarly, Excel documents can be saved in many different file formats. By changing the Excel file format to “xlsx” (or “xls” for older programs), you can fix this problem.
- 2 Open Finder. Click the blue, face-shaped app icon in your Mac’s Dock.
- 3 Select the Excel file. Go to the folder in which your Excel file is located, then click the Excel file that you want to recover.
- 4 Click File, This menu item is in the top-left corner of your Mac’s screen. Clicking it prompts a drop-down menu.
- 5 Click Get Info, It’s in the File drop-down menu. This will open a pop-up window.
- 6 Expand the “Name & Extension” section if necessary. If you don’t see any file name or extension below this category, click the triangle to the left of the “Name & Extension” heading to view the file’s name and extension.
- 7 Change the file type. Replace whatever comes after the period at the end of the file name with xlsx and then press ⏎ Return,
- For example, if the document was named “Spreadsheet1.txt”, you would change it to “Spreadsheet1.xlsx”.
- If the file extension already is “xlsx”, try using “xls” or “html”.
- 8 Click Use,xlsx when prompted. This will confirm your decision and change the file type.
- 9 Try opening the file. Double-click the file to open it. If the file opens in Excel (or, if you selected “html” as the extension, a web browser), your file has successfully been recovered.
- If you chose the “html” extension, you can convert the webpage into an Excel document by dragging the html file onto the Excel icon and then saving the file that opens as a new “xlsx” file.
- If the file still won’t open, proceed to the next Mac method,
Advertisement
- 1 Understand the limitations of this method. Like most Microsoft Office products, Excel will automatically save recovery versions of files, meaning that you may be able to restore a partial version of your corrupted Excel document. However, Excel doesn’t always save these files in time, and you most likely won’t be able to recover the whole document in this way.
- 2 Open Start, Click the Windows logo in the bottom-left corner of the screen.
- 3 Type in this pc, This will search your computer for the “This PC” program.
- 4 Click This PC, It’s the computer monitor-shaped icon at the top of the Start window. Doing so opens the This PC window.
- 5 Double-click your computer’s hard drive. This is usually the “OS (C:)” option below the “Devices and drives” heading in the middle of the page.
- 6 Double-click the “Users” folder. You’ll find this in the middle of the hard drive’s folder.
- 7 Double-click your user folder. This folder is labeled with part or all of your username on your computer.
- 8 Double-click the “AppData” folder. It’s in the “A” section, so you’ll most likely find this folder near the top of the window.
- If you can’t find this folder, click the View tab, then check the “Hidden items” box in the “Show/hide” section to prompt the “AppData” folder to appear.
- 9 Double-click the “Local” folder. This option is near the top of the folder.
- 10 Scroll down and double-click the “Microsoft” folder. You’ll find it in the “M” section.
- 11 Double-click the “Office” folder. It’s in the “O” section of the Microsoft folder.
- 12 Double-click the “UnsavedFiles” folder. This folder should be near the top of the window.
- 13 Select an Excel file. Look for an Excel file icon that has a name matching your corrupted Excel file, then click it to select it.
- If you don’t see any files here, a recovery version of your Excel document was not saved.
- 14 Change the Excel file’s extension. To do so:
- Click View
- Check the “File name extensions” box.
- Click Home
- Click Rename
- Replace the,tmp section with,xlsx
- Press ↵ Enter,
- Click Yes when prompted.
- 15 Open the Excel file. Double-click the file that you just renamed to open it.
- 16 Save your file. Once the restored file opens, press Ctrl + S, double-click This PC, select a save location, enter a file name, and click Save,
- Be sure to select a different file name than the one which you used for the corrupted Excel file.
Advertisement
- 1 Understand the limitations of this method. Like most Microsoft Office products, Excel will automatically save recovery versions of files, meaning that you may be able to restore a partial version of your corrupted Excel document. However, Excel doesn’t always save these files in time, and you most likely won’t be able to recover the whole document in this way.
- 2 Click Go, This menu item is at the top of the screen. Clicking it prompts a drop-down menu.
- If you don’t see the Go menu item, first open Finder or click the desktop to make it appear.
- 3 Hold down the ⌥ Option key. After doing this, you should see the Library folder appear in the Go drop-down menu.
- 4 Click Library, It’s in the Go drop-down menu. This will open the Library hidden folder.
- 5 Open the “Containers” folder. Double-click the “Containers” folder, which is in the “C” section of the Library folder.
- 6 Click the search bar. It’s in the upper-right side of the window.
- 7 Search for the Microsoft Excel folder. Type in com.microsoft.Excel and press ⏎ Return,
- 8 Click the Containers tab. You’ll find this to the right of the “Search:” heading near the top of the Finder window.
- 9 Open the “com.microsoft.Excel” folder. Double-click this folder to open it.
- 10 Open the “Data” folder.
- 11 Open the “Library” folder.
- 12 Open the “Preferences” folder. If you don’t see this folder, scroll down to find it.
- 13 Open the “AutoRecovery” folder. This will bring up a list of automatically saved versions of your Excel files.
- 14 Find a temporary version of your Excel file. The temporary version of your Excel file should have some or all of the file’s name in its title.
- If you can’t find the temporary version of your Excel file, it wasn’t backed up.
- 15 Select the Excel file. Click the Excel file to do so.
- 16 Click File, It’s a menu item in the upper-left corner of your Mac’s screen. A drop-down menu will appear.
- 17 Select Open With, This option is near the top of the File drop-down menu. You should see a pop-out menu open.
- 18 Click Excel, It’s in the pop-out menu. Doing so will prompt the temporary version of the Excel document to open in Excel.
- The temporary version will probably not include some of your most recent changes to the original Excel document.
- 19 Save the document. Press ⌘ Command + S, then enter a file name, select a save location in the “Where” menu, and click Save,
Advertisement
Add New Question
- Question I cannot open the file with my Excel file, but I can open it in another computer. Why? It’s likely that the other computer has either an older or newer version of Excel, and your document is not compatible with the version you have on your computer.
- Question What do I do if my Excel files are save with the extension xls? Nakamura Rei Community Answer You can repair,xls files using methods from this article as well as xlsx.
- Question How do I recover a deleted excel file in Windows 7? y\You can use the same method. However, to change the file extension you will need to use CMD and run a command like this (make sure you are in the right directory): rename (corrupted excel file, add its file extension at the end) (corrupted excel filename, do NOT add the file extension at the end).(xls, xlsx).
Ask a Question 200 characters left Include your email address to get a message when this question is answered. Submit Advertisement
- Windows computers will often attempt to repair automatically the corrupted Excel workbook when you open it.
- You may be able to open an otherwise corrupted Excel file by placing your computer in safe mode, If so, a file error or a virus is most likely the reason for your document failing to open.
- There are a few paid data recovery software options that you can use to recover corrupted Excel files. Stellar Phoenix Excel Repair, which is available for both Windows and Mac computers, is a good example of such a program.
Thanks for submitting a tip for review! Advertisement
Unfortunately, some Excel files may be entirely unrecoverable.
Advertisement Article Summary X 1. Open Excel.2. Select Open Other Workbooks,3. Select the corrupted file.4. Click the down-arrow menu next to “Open.” 5. Select Open and Repair,6. Click Repair,7. Click Close when complete. Did this summary help you? Thanks to all authors for creating a page that has been read 1,333,549 times.
Pogledajte cijeli odgovor
How do you restore a corrupt Excel file?
- Locate your Excel file and right-click on it and select Properties.
- Select the Previous Versions tab and find the working version of the file and select Restore.
- Select the folder where you would like to save the recovered file.
How to recover a file that was not saved in Excel?
Part 5 : FAQs of recovering an excel file – 1. How to Recover an unsaved excel file in Excel? Launch MS Excel application you were using. Open a new file or any existing file. Click the File tab. Find Info and then choose Manage Versions. At last, click Recover Unsaved Workbooks.2.
- How do I get Excel to autosave? Go to the File tab and choose Options from the File menu.
- Click Save on the left-hand pane of the Excel Options dialog.
- Make sure that both Save AutoRecover information every X minutes and Keep the last autosaved version if I close without saving are checked.
- Click OK.3.
Can I restore replaced XLS file from the previous version? If your XLS files got replaced or saved over, relax. You can follow the step-by-step guide in Part 3 of this page, and then you can get your Excel file XLS restored without losing any saved data.
Pogledajte cijeli odgovor
How to repair a damaged Excel file?
- Select a location to start finding crashed or damaged Excel files
- Repair and recover corrupted Excel files.
- Save the recovered Excel file to a secure location.
How to restore an unsaved or overwritten Microsoft Excel file?
Method 4. The Ultimate Way to Recover Unsaved/Lost Excel File on Windows/Mac – Each of the methods mentioned above have their limitations and if they could not help you recover your Excel file, this method will do. Meet Tenorshare 4DDiG for Windows Data Recovery a software that allows users to recover precious data on your computer.
Download and run the software on your computer. Select the drive where your Excel file was saved and click on the button that says Scan. The software will scan the drive for you. When the drive is scanned, you will see the files that can be recovered. Click on the ones you want to recover and hit the button that says Recover at the bottom-right corner. A prompt will appear asking where you would like to save the recovered files. Select a safe location for your files on your computer.
You are all set. Your chosen files have been recovered and saved in your selected folder. You may also be interested in How to Recover Unsaved Word Documents? or How to Recover Unsaved Power Point?
Pogledajte cijeli odgovor