Open Finder. Click the blue, face-shaped app icon in your Mac's Dock. 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. Click File. This menu item is in the top-left corner of your Mac's screen. Clicking it prompts a drop-down menu.
Click Get Info. It's in the File drop-down menu. This will open a pop-up window. Click Use. This will confirm your decision and change the file type. If the file still won't open, proceed to the next Mac method. Method 4. 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. Type in this pc. This will search your computer for the "This PC" program. Click This PC. It's the computer monitor-shaped icon at the top of the Start window.
Doing so opens the This PC window. 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. Double-click the "Users" folder. You'll find this in the middle of the hard drive's folder. Double-click your user folder. This folder is labeled with part or all of your username on your computer. 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.
Double-click the "Local" folder. This option is near the top of the folder. Scroll down and double-click the "Microsoft" folder. You'll find it in the "M" section. Double-click the "Office" folder.
It's in the "O" section of the Microsoft folder. Double-click the "UnsavedFiles" folder. This folder should be near the top of the window. 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. Change the Excel file's extension.
Click Home Click Rename Replace the. Open the Excel file. Double-click the file that you just renamed to open it. Method 5. Click Go.
This menu item is at the top of the screen. If you don't see the Go menu item, first open Finder or click the desktop to make it appear.
After doing this, you should see the Library folder appear in the Go drop-down menu. Click Library. It's in the Go drop-down menu. This will open the Library hidden folder. Open the "Containers" folder. Double-click the "Containers" folder, which is in the "C" section of the Library folder. Click the search bar. It's in the upper-right side of the window. Search for the Microsoft Excel folder. Type in com. Click the Containers tab. You'll find this to the right of the "Search:" heading near the top of the Finder window.
Open the "com. Excel" folder. Double-click this folder to open it. Open the "Preferences" folder. If you don't see this folder, scroll down to find it.
Open the "AutoRecovery" folder. This will bring up a list of automatically saved versions of your Excel files. In this respect, Excel can help. If you attempt to open a corrupted workbook, Excel will engage File Recovery mode, which attempts to repair the workbook.
If that works, great! Unfortunately, Excel's automated File Recovery feature sometimes fails to repair a damaged workbook. When this happens, you'll need alternatives. Try the easiest solutions first. The more complex methods usually recover data, but no formulas, formatting, charts, or macros.
Note: This article is also available as a PDF download. If Excel's automatic recovery mode fails, there's a manual feature for recovering a corrupted workbook:. If you're lucky, Excel will repair the file. However, this feature recovers files when something goes wrong with Excel, so it won't recover every corrupted file. Once you've made every attempt to recovery the file, you might have to make do with recovering just the data.
When that's the case, click Extract Data in step 4. If corruption occurs while the workbook is open, do not save the workbook. You'll just save whatever corrupted the workbook along with the most recent changes. Instead, revert to the last saved version. Doing so, without saving first should discard the corrupted component.
You'll possibly lose data, but often, you can rebuild quickly enough a good reason to save your work often. If Excel fails to open the file on its own or via the Open And Repair option, try setting the calculation method to manual and try again. To reset the calculation setting:. Then, try to open the corrupted workbook.
Sometimes Excel can open a corrupted workbook if it doesn't have to recalculate. The recovery tool will close Excel and then restart it, displaying a list of recovered workbooks if any. If you're lucky, your corrupted workbook will be in the list. Simply open it and count your blessing. Sometimes, a corrupted workbook isn't really corrupted in the traditional sense. It just isn't accessible as usual; networks and servers often mask errors as corrupted files.
Let us have a look at some of the most common reasons due to which an Excel file can get corrupted. While Excel automatically starts the File Recovery mode when it detects a corrupt spreadsheet and there are other methods too in the Excel program that can be used to recover the corrupted files, these methods are hardly useful most of the time.
While there are many different Excel repair tools available online, one of the most useful is Stellar Phoenix Excel Repair. The software allows you to recover a corrupt Excel file while ensuring that all the original formatting which you did on the sheet remains intact. Right from the tables that you have modified, charts you have created, comments in cells, images, engineering formulas, etc.
Stellar Phoenix Excel Repair is one of the best software to recover a corrupt Excel file which is not just effective but very easy to use as well. To recover corrupt Excel files with Stellar Phoenix Excel Repair tool, use the below-mentioned steps. Step 2 You can check all corrupt Excel files display in the result section, and select multiple files start to repairing process. Step 3 If you want to Preview the file before recovering it, right-click the file under the file tree for the preview.
Step 4 Select your preferred local drive to save the repaired Excel files. Also, if you have used engineering formulas in your corrupted file and want to make sure that they remain intact, you'd be required to install the 'Analysis ToolPak' add-in. While you can always use Stellar Phoenix Excel Repair software to recover a corrupt Excel file, it is also important to prevent such occurrences.
Use the tips mentioned below to considerably minimize the chances of your Excel file getting corrupted. Use these tips and the chances of your Excel file getting corrupted will be close to none.
While the features of the Demo version of this software are limited, it is still a great way to check how effective the software is.
0コメント