This page includes solutions on how to recover deleted Excel 2016, recover unsaved excel files, and restore crashed Excel on saving or opening files. If you are facing one of the problems in Windows 10/8/7, follow solutions here to perform Excel recovery and bring your lost Excel 2016 files back now.
Yes, you can install and use Office 2016 for Mac and Office for Mac 2011 at the same time. However, we recommend that you uninstall Office for Mac 2011 before you install the new version just to prevent any confusion. To uninstall Office for Mac 2011, follow the steps in Uninstall Office 2011 for Mac. How do I pin the Office app icons to the dock? Connecting on a Mac via SMB. Creates temp folders that only an admin can delete. Connecting from a Windows (W7) machine on OS High Sierra Server 5.4 and opening an Office 2016 doc leaves.TMP files in the directory. I regret updating this mac mini that I use as a file server for a small department, should just kept it on Yosemite server. Office 2016 for Mac license. If you choose to upgrade to Microsoft 365 or Office 2019 for Mac, you'll simply need to remove the existing Office 2016 for Mac license, but you won't need to remove your Office apps. Download and run the License Removal Tool. Support for Office 2016 for Mac ended on October 13, 2020. All of your Office 2016 apps will continue to function. However, you could expose yourself to serious and potentially harmful security risks. Upgrade to a newer version of Office.
On this page, EaseUS software will offer complete solutions to help you perform Microsoft Excel 2016 file recovery with ease.
If you accidentally deleted important excel file, lost Excel 2016 by mistake, Excel crashed on saving or opening files in Windows 10/8/7, follow offered methods here to bring your lost Excel files back now:
| Workable Solutions | Step-by-step Troubleshooting |
|---|---|
| Fix 1. Recover deleted Excel | 3 ways available: use Excel file recovery software; undelete Excel 2016 from recycle bin and temp...Full steps |
| Fix 2. Recover unsaved Excel | Recover unsaved Excel from AutoRecover folder or restore unsaved Excel from previous versions...Full steps |
| Fix 3. Restore crashed Excel | Restore crashed Excel 2016 by using Microsoft Repair Office and Open and Repair...Full steps |
Recover Deleted Excel 2016
Applies to: Recover deleted, lost Excel files on Windows PC.
Method 1. Use Excel File Recovery Software
Professional file recovery software - EaseUS Data Recovery Wizard supports you to effectively recover deleted, lost Excel file in Windows 10, 8 or 7 within 3 simple steps.
Just download, install this file recovery software and apply it to restore excel file now:
Step 1. Specify a location.
Run EaseUS Data Recovery Software. Choose the drive X: or perhaps a specific folder on Desktop or somewhere else where you lost the excel files, and then click 'Scan'.
Step 2. Scan for data.
During the scan, you'll see more and more data showing up very quickly in the 'Deleted files' result. That's part of what the software has found and displayed. To quickly find the Excel files in the massive data in the scan results, click on the 'Filter' on the top area and choose 'Documents'. Or, search .xls or .xlsx in the Search box.
Step 3. Preview and recover.
You can double click on a file to preview its integrity. Finally, select the desired files and click 'Recover'.
If you prefer to manually restore lost Excel files in Windows PC, try the next two methods below to restore your Excels.
Method 2. Undelete Excel 2016 from Recycle Bin
If you deleted or removed Excel files from Desktop or file folders in your PC, undeleting Recycle Bin may help you get the deleted Excel file back:
Step 1. Open Recycle Bin and find deleted Excel 2016 files with .xlsx extension.
Step 2. Right-click on lost XLSX files and select 'Restore'.
Then deleted Excel file will be restored back to the original location on your PC.
Method 3. Recover Deleted Excel 2016 from Temp Files
If you've emptied the Recycle Bin, you may also try to find deleted excel files from the .temp files in Windows PC:
Step 1. Follow the below-listed temp file folder location on your PC and find the Excel temp files with .TMP extension:
- For Windows 8/10 users: C:UsersnameAppDataLocalMicrosoftOfficeUnsavedFiles
- For Windows 7 users: C:UsersnameAppDataRoamingMicrosoftExcel
Step 2. Locate and find the temporary excel files begin with '$' or '~' and end with '.TMP'.
Step 3. Copy these files and save to another safe spot by changing the extension from '.TMP' to '.XLS' or '.XLSX'.
Recover Unsaved Excel 2016
Applies to: Restore unsaved Excel files due to a sudden close, virus attack or even power supply accident, etc.
To restore unsaved Excel 2016 files in Windows 10/8/7, there are two methods that you may also follow either one below to get your problems solved:
Microsoft Office 2016 For Macs
Method 1. Recover Unsaved Excel 2016 from AutoRecover Folder
Note that this method only works when you have enabled the AutoRecover feature in advance. If you didn't enable this feature, move to try the next method for help.
Step 1. Open Office file or a new Excel document in Windows PC.
Step 2. Click 'File' and 'Recent', check recent used Excel documents and find the exact one - unsaved Excel document.
Step 3. Click 'Recover Unsaved Workbooks' and then wait till the Excel document is retrieved.
Step 4. On the Open dialog, open the exact lost Excel and click 'Save As' to save the document into a safe spot on PC.
Method 2. Recover Unsaved Excel from Previous Versions
If you didn't enable the AutoRecover feature and you want to bring the unsaved Excel file back, you can follow below tips restore part of the lost or unsaved Excel from its previous version.
Step 1. Create a new Excel file with the same name as your lost Excel file or find your present Excel file.
Step 2. Open the excel file and click on the 'Files' tab, click on 'Info'.
Purchase Office 2016 For Mac
Step 3. Next to the 'Manage Versions', you'll be able to see all autosaved versions of your Excel file.
Step 4. Double click the most recent version and check the Excel content. If it's the lost unsaved Excel, save it as a new Excel document.
Then you'll get Excel 2016 file restored from previous/saved versions.
Restore Crashed Excel 2016 on Saving or Opening Files
Applies to: Restore crashed Excel while saving or opening a file.
If your Excel files or Word documents crashed on saving or opening files, don't worry. Here below two methods will help you out and restore your crashed Excel 2016:
Method 1. Repair Office to Restore Crashed Excel 2016
Step 1. Restart your PC and open Control Panel.
Step 2. Click Programs and Settings, then find and click Office.
Step 3. Right-click on 'Change', a repair dialog will appear.
Step 4. Check 'Quick Repair' and click 'Repair'. Then open Excel to see if problems got fixed or not.
Step 5. If not, select 'Online Repair' and wait for the repair process to complete.
After this, you can open the crashed Excel file and it shall work by then.
Method 2. Restore Crashed Excel by Open and Repair
Step 1. On the File tab, click Open.
Step 2. In Excel 2016, click on the location where the spreadsheet is loaded, and click Browse.
Step 3. In Open dialog, select the corrupted or crashed Excel file that you want to open.
Step 4. Click the arrow next to the Open button, and then click Open and Repair.
- If you want to recover as much of Excel data as possible, click 'Repair'.
- If you want to extract values and formulas from the Excel when an attempt to repair the Excel is not successful, click 'Extract Data'.
Summary
Excel temp files give you the potential to recover the deleted or lost Excel files. However, once the temp files are lost, you should take Apeaksoft Data Recover to recover the Excel files on your Windows and Mac computer.
Free DownloadFree Download'I opened an Excel file from my email, and then made some changes, but my computer suddenly powers off, can I get back my edited Excel file? Please help.'
Microsoft has realized such demands and introduced temporary files for Excel. It will save your changes in Excel temp files regularly.
In other word, finding the Excel temp files, you can get back your data if the Excel file is not saved in time due to sudden interruptions.
In this tutorial, we are going to tell you where are temporary Excel files stored on Windows 10/8/8.1/7/XP and Mac OS X/11 and how to recover your data through temp files.
Part 1: Where are temporary Excel files stored
When you create a new Excel file or start editing it, Windows will produce a temp file as well. And the temp file stays on your computer until you click on the Save button.
But it may be stored in different locations depending on where the Excel file saved and which version of Windows you are using.
For example, the Excel temp file is stored in:
Windows 10: C:UsersAppDataLocalMicrosoftOfficeUnsavedFiles.
Windows 7 or XP: The directory is C:Documents and Settings
Bear in mind that the name of the temp file does not look like a normal file, usually containing a squiggly line or other symbols and end with TMP.
You will also like: Recover unsaved Excel file.
Part 2: Regular way to recover Excel temp files
When you encountered sudden interruptions, like Excel file corrupted, Excel file not responding, etc. you can get back your Excel Windows 10/8/7/XP through temp files. But you may discover that it is infeasible to open the temp file directly. Follow the methods below to recover Excel temp files quickly.
Method 1: Recover Excel temp files by changing extension
Step 1Go to where temporary Excel files stored according to your situations, highlight it, press 'Ctrl + C', navigate to another location, press 'Ctrl + V' to paste the temp file there.
Step 2Locate to the top ribbon, go to the View tab and check the box of 'File name extensions'. After that, you can right-click on the Excel temp file to change the file extension to xlsx or xls.
Step 3Now, you can open Excel temporary file as a real workbook.
Method 2: Open temp files in Excel
Though you cannot open Excel temp file directly, it does not mean the Excel program is not able to load it.
Step 1Run Excel program from your desktop, go to 'File' > 'Info'.
Step 2Click on the 'Manage Versions' and select 'Recover Unsaved Workbooks'.
Step 3On the popup dialog, navigate to where temp files stored and open it in Excel program. Now, you can save your data as a normal Excel file.
Part 3: Best method to restore Excel temporary files
If your Excel file is corrupted or damaged, we suggest you try a professional data recovery tool, such as Apeaksoft Data Recovery.
Step 1Scan entire drive to look for data
Download Data Recovery and install it on your PC. If your Excel file stored on an external drive originally, connect it to your computer. Launch the best Excel temp file recovery software.
Go to the data type section on the home interface, and tick the checkbox on the 'Document' option. Then go to the location area and select where are temporary Excel files stored. Once you click on the 'Scan' button, Data Recovery will work automatically.
Step 2Preview Excel files before recovery
After quick scanning, you will be brought to the result window. Go to the Document tab from left-hand column, you will be presented several folders titled XLSX, XLS, DOC, PDF, etc.
Click the folders related to Excel file formats, like XLSX and preview files. Plus, the 'Filter' feature at the top ribbon could help you to find the Excel file that you want to recover quickly.
If you cannot find the desired file, click on the 'Deep Scan' button at the upper right corner. It will take more time to scan the drive deeply and find more recoverable data.
Step 3Recover Excel temporary files in one click
To restore lost data, you can check the box in front of each desired Excel file or select the entire folder.
Click on the 'Recover' button to start restoring Excel files. When it is done, you can browse, copy and paste, or edit your data as usual.
The steps to recover temp Excel files on Windows are slightly different from on Mac. Check here to recover deleted files on Mac.
Data RecoveryData Recovery is the easiest Excel temp file recovery tool, which can recover .xls, and .xlsx in Excel 2000, 2003, 2007, 2010, 2016, etc. on Windows 10/8/7 and Mac, whether your Excel temp file is lost or deleted due to mistake operation, virus attack, software corrupt, or sudden power off.
Part 4: FAQs of Excel temp files
1. How do I clear temp files in Excel?
You just need to go to the location that stores the Excel temp files, and select the temp files. Drag them into the trash. For deleting them permanently, you should empty your trash.
2. How to stop temp files from creating in Excel?
For stopping the temp files from creating in Excel, you just need to disable the settings. Click Tool at the top-left corner, select Options, go to the Save tab and select the checkbox of Disable Auto recovery. Then it will not create the Excel temp files.
3. Access denied to delete Excel temp file in network share, how to fix?
You can try the following solutions: Firstly, upgrade SEP (End Point protection) to the latest version. Secondly, rename a parent folder. If it still cannot be fixed, just use Troubleshooting in Microsoft Office.
4. Excel cannot open or save a file and the temp folder is full, how to fix?
Right-click on the saved Excel file, click on Properties and uncheck the option Block and then try to open the Excel file and check.
Conclusion
Excel is one of the most useful programs on Windows. People use it to save and visualize oceans of data, from financial to sales. But many users have encountered the problem that closes the workbook without saving. Fortunately, Excel temp files save your data and change waiting for recovery. We have shared how to find and use Excel temp files in this tutorial. In another world, even if you do not enable the automatic save feature, it is possible to recover data from temporary files created by Office and Windows.
We wish that our guides and suggestions are helpful. If you have more questions related to Excel temp files, please leave a message below.