Fix 1 – Checking Unblock in File Properties
- Right-click on the file.
- Select the Properties option.
The File Opening Problem.xlsx Properties wizard will open up.
- Check the Unblock option and click on Apply.
- Press OK.
In this way, we have fixed the problem and we will be able to open the file.
- Open the file.
The file should be opened successfully without an error message.
Read More: [Fixed!] Why Is My Excel Not Opening Files?
Fix 2 – Disabling Protected View Options
- Open a blank workbook.
- Click on the File tab.
- Select Options.
- Select the Trust Center option.
- Click on Trust Center Settings.
- Click on the Protected View option and uncheck all of the Protected View options.
- Press OK.
- Try to open the Excel file by double-clicking on it.
We have successfully opened this file after fixing the issue.
Read More: [Fixed!] Excel File Not Opening on Double Click
Fix 3 – Changing the Trusted Locations
- Open a blank workbook.
- Click on the File option.
- Select Options.
- Select the Trust Center option.
- Click on Trust Center Settings.
- Click on the Trusted Locations option and select the Add new location option.
- Select Browse.
- Enter the path of the new location in the Path box and make sure to check the option Subfolders of this location are also trusted.
- Press OK.
You will be taken to the Trust Center dialog box again.
- Press OK.
- Try to open the Excel file.
The file should be opened successfully without an error message.
Read More: [Fixed!] Excel Attachments Not Opening from Outlook
Fix 4 – Deleting Temp Files
- Go to the View tab of the File Explorer window and check the option Hidden items.
- Go to the following path:
This PC\Local Disk(C:)\Users\[Name]\AppData\Local\Temp
- The username is different for your computer, so click on the username of your computer.
- Select all of the files in the Temp folder by pressing Ctrl + A and Delete them.
- Open the file you need.
We have successfully opened this file without facing any issues.
Related Articles
- [Fixed!] Unable to Open Excel Files Directly by Clicking on the File Icon
- [Fixed!] Excel File Open but Not Visible
- [Fixed!] Excel File Opens Blank Grey Screen
- Unable to Open Two Excel Files at the Same Time
- Excel Files Not Opening in Separate Windows
<< Go Back to Excel Not Opening Files | Excel Files | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
Thank you so much for saving me. I have been struggling with opening word and excel files for months, and were about to replace MS. Office with WPS. I succeeded in opening them when trying Fix 1 and 2. You are angel. Wish you all the best.
Hello Nhung,
Your appreciation means a lot to us. We are glad that our article helped you to fix your issues.
Regards
ExcelDemy