Fixed Microsoft Excel 2000 Cannot Access the File Error | Stellar

Fixed Microsoft Excel 2000 Cannot Access the File Error | Stellar

Nova Lv12

[Fixed] “Microsoft Excel Cannot Access the File” Error

Summary: The “Microsoft Excel cannot access the file” error usually occurs when there is an issue with the Excel file you are trying to save. This post summarizes the causes behind the error and mentions some effective solutions to fix it. If you suspect the problem is encountered due to corruption in the Excel file, you can use the professional Excel repair tool mentioned in the post to repair the file.

Free Download for Windows

You may experience the “Microsoft Excel cannot access the file” error when saving the Excel file. This happens when the Excel application fails to read the file you are attempting to save. The error message indicates that there is an issue with the file name or its path. Sometimes, the error occurs if the file you are trying to access is already in use by another application. Some other reasons for the “Excel cannot access the file” error are:

  • Faulty or incompatible Excel add-ins.
  • The file is in Protected View.
  • The Excel file is damaged or corrupted.
  • You do not have the required permissions to access the file.
  • The Excel file is not in a compatible format.

Methods to Fix “Microsoft Excel Cannot Access the File” Error

Sometimes, changing the file location can fix the “Microsoft Excel cannot access the file” error. You can try changing the file location, if the location is incorrect. If moving the file to a different location didn’t work, then try the below troubleshooting methods.

Method 1: Check the File Name and Path

You can get the “Microsoft Excel cannot access file” error if there is an issue with the file path – either the path does not exist or it is too lengthy, thus creating conflicts. Make sure the file path is correct. If the file name is too long, you can rename the file with a short name and also move the file to the parent folder instead of a subfolder. After that, remove the file from the Recent list that is created by Excel based on your recent activity. Follow the below steps:

  • Open the Excel application.
  • In the Recent list, right-click on the affected Excel file.
  • Now, select Remove from list.

Selecting the "remove from list" option

  • Close the Excel application.

Now, reopen the problematic file and check if the error exists. If yes, then follow the next solution.

Method 2: Try Clearing the Microsoft Office Cache

Sometimes, clearing the Microsoft Office cache can help eliminate the “Excel cannot access the file” error. To clear the Microsoft Office cache, follow the given steps:

  • First, close all the Office applications.
  • Press Windows+R to open the Run window.
  • Type %localappdata%\Microsoft\Office\16.0\OfficeFileCache and press the Enter key. You can change ‘16.0’ with your Office version.

Clearing Microsoft Cache from officefilecache Window

  • In the OfficeFileCache window, clear all the temporary files.

Method 3: Check and Update Microsoft Excel

You can try updating your Microsoft Excel application. The latest updates include bug fixes, security patches, and other improvements. Updating the application can help fix several issues that might be causing the error. Here are the steps to update Microsoft Excel:

  • Open your Excel application.
  • Go to File and then select Account.
  • Under Product information, click Update Options and then click Update Now.

Method 4: Disable Protected View

You may get the “Microsoft Excel cannot access the file” error if the Protected View option is enabled. You can try disabling the Protected View settings in Excel. This allows you to open the file without any restrictions. However, disabling the protected view can put your system at high risk. To disable the Protected View in Microsoft Excel, follow the below steps:

  • In Excel, go to File and then click Options.
  • In the Excel Options window, click Trust Center and then click Trust Center Settings.

Go To Trust Center and Click on Trust Center Settings

  • Click Protected View from the left pane in the Trust Center Settings window.
  • Unselect the options under Protected View. Click OK.

Method 5: Check and Disable Add-ins

The “Excel cannot access the file” error can also occur due to faulty add-ins in Excel. To check if the error has occurred due to some faulty add-ins, open the application in safe mode (press Windows + R and typeexcel /safe in the Run window**)**. If you can save the file without any hiccups in safe mode, this indicates some problematic add-ins are behind the error. You can remove the Excel add-ins by following these steps:

  • Open your Excel application and go to File > Options.

  • In Excel Options, select Trust Center and then click Trust Center Settings.

  • In Trust Center Settings, click Add-ins and thenselect “Disable all applications Add-ins”. Click OK.

Go to 'Add ins' and select disable all application add ins

Method 6: Check File Permission

You can get the “Excel cannot access the file” error if you don’t have sufficient permissions to modify the Excel file. You can check and provide the write permissions to fix the issue. Here’s how to do so:

  • Open Windows Explorer.
  • Find the affected Excel file, right-click on it, and click Properties.

Click Properties Option

  • In the Properties window, click the Securities option and click Edit.

Go to Security and then click Edit option

  • In the Security window, select the user names under ‘Group or users name’.
  • Check the file permissions and make sure the write option is enabled. If not, then grant the permission. Click Apply and then OK.

The “Excel cannot access the file” error can also occur due to broken external links in the Excel file. External links are references to the data or content in other files. The link usually breaks if the file has been moved to another location or the file name is changed. You can check and change the source of link.

Method 8: Repair your Excel File

Excel may fail to read the file if it is corrupted or damaged. If the error “Excel cannot access the file” has occurred due to file corruption, then try the Excel’s Open and Repair utility to repair the Excel file. Here are the steps:

  • In the Excel application, click the File tab and then select Open.
  • Click Browse to select the problematic workbook.
  • The Open dialog box will appear. Click on the corrupted file.
  • Click the arrow next to the Open button and then select Open and Repair.
  • You will see a dialog box with three buttons – Repair, Extract Data, and Cancel.

Click repair option

  • Click on the Repair button to recover as much of the data as possible.
  • After repair, a message is displayed. Click Close.

If the Open and Repair utility fails to work , it indicates the Excel file is severely corrupted. Use Stellar Repair for Excel to repair severely corrupt Excel file. It helps recover all the components of the corrupted Excel file, such as charts, formulas, etc. without making any changes to the original file. It can also fix all types of corruption-related errors. You can use Stellar Repair for Excel to repair Excel files created in all Excel versions – from 2007 to 2023.

Closure

The “Microsoft Excel cannot access the file” error can occur due to numerous reasons. Follow the troubleshooting methods, such as checking file location, path, permissions, etc., as discussed above to fix this error. Sometimes, Excel throws this error if the file you are trying to save is corrupted. You can try repairing the file using the built-in utility – Open and Repair. If the file is severely corrupted, then you can use Stellar Repair for Excel . It can repair damaged Excel files (.xls, .xlsx, .xltm, .xltx, and .xlsm) with complete integrity.

[Fixed] Excel Cannot Open the File Because the File Format or File Extension Is Not Valid

When opening an older version of an Excel file in a newer version, you may encounter the “Excel cannot open the file because the extension is not valid” error. This happens if you have accidentally renamed the file with a different file format or an incorrect file extension. Also, you may get the ‘Excel cannot open the file’ error if the file has become unreadable or corrupted.

This is how the complete Excel error message looks like:

“Excel cannot open the file filename.xlsx because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file.”

Excel Cannot Open the File Extension Not Valid Error

Check out this video for a quick demonstration of how to fix “Excel Cannot Open the File Because the File Format or File Extension Is Not Valid”

How to Fix the ‘Excel Cannot Open the File Because the File Format or Extension Is Not Valid’ Error?

Try any of these workarounds to fix the error and regain access to your Excel file data:

Workaround 1 – Change the Default File Format

By default, an Excel file is saved in .xlsx or .xls file format. Trying to open the file with a different or incorrect extension may cause the ‘Excel cannot open the file because the extension is not valid’ error. To fix the error, try changing the Excel default file format by following these steps:

Note: Take a backup of the Excel file that you cannot open and try the steps on the backup copy.

  • In Excel 2010 and newer versions, click on the File menu.

Note: For Excel 2007 and earlier versions, click on the Office button.

  • On the left panel, click on Options
  • In ‘Excel Options’ window, under Save workbooks section, click on the Save files in this file format: drop-down. Select a file format (i.e., the one supported by your Excel version).

Save Workbook in Other File Format

  • Click OK.

Check if you can open your Excel file. If not, try the next workaround.

Workaround 2 – Edit the Excel File Permissions

You may receive the ‘Excel file format or file extension is not valid’ error if you lack sufficient permissions to open the file. Usually this happens when you try to open an Excel file received from some other user. Follow these steps to change the file permissions and see if it fixes the problem:

  • Right-click on the file that won’t open and click Properties.
  • In the file properties dialog box, click the Security tab and then hit the Edit button.

Edit Excel File Properties

  • When the file’s permissions dialog box appears, click on the Add button.

Add Excel File Permissions

  • Click on the Advanced button from the ‘Select Users or Groups’ window.

Open Advanced Settings

  • Select Find Now. A list of all users and groups will get displayed in a search results box. Choose Everyone group from the list and hit OK.

Select Everyone Group

  • You can see the ‘Everyone’ group in the ‘Enter the object names to select’ textbox. Click OK once again to return to the file’s permission dialog box.

Everyone Group is Added Users Groups

  • Click Everyone from the Group or user names: box and check all the checkboxes under Allow.

Allow Permissions for Everyone

  • Click on Apply and then OK.

Now try to open the Excel file. If you’re still getting the Excel file cannot open error, use the following workaround.

Workaround 3 – Recover Unsaved Workbook

If the ‘Excel file extension not valid error’ occurs when attempting to open an unsaved workbook, do the following to recover the unsaved workbook:

  • In Excel, click File. 
  • From the Info screen, under Manage Versions, click Recover Unsaved Workbooks.

Recover Unsaved Workbooks

Excel will list any unsaved files. Try opening the file and save it. If this doesn’t work, skip to the next workaround.

Workaround 4 – Repair the Workbook

If none of the above workarounds has worked for you, chances are that the Excel file has become corrupted. Try to repair the file using the Excel inbuilt ‘Open and Repair’ utility by following these steps:

  • In your Excel application, click on File > Open.
  • In the ‘Open’ dialog box that pops-up, select the Excel file you want to repair and click the arrow next to the Open button.

Select Excel File for Repairing

  • From the dropdown list, select Open and Repair.

Open and Repair Excel File

  • Excel will ask you to attempt to repair the file or extract data from it. Click Repair to retrieve maximum data. If the Repair option fails, click on Extract Data to recover the data without formulas and values.

Repair Excel File

If the ‘Open and Repair’ utility doesn’t help fix the corrupted file and/or recover the data, use an Excel repair tool  such as Stellar Repair for Excel to regain access to your file and its data.  

free download

Stellar Repair for Excel software can help repair severely corrupted XLS and XLSX files. Also, it helps recover all the file components, including tables, pivot tables, cell comments, charts, chart sheets, images, formulas, etc., without impacting the original structure of the Excel file. 

To learn how the software works, read this: How to repair corrupt Excel file using Stellar Repair for Excel?

Conclusion

You may encounter the error ‘Excel cannot open the file because the extension is not valid’ when opening a workbook with a different file format or an incorrect file extension. Also, the error may occur if the Excel file has turned corrupt. This article has covered some of the most effective workarounds to resolve the error. But if nothing works, you can try to repair the Excel file and retrieve its data using the Stellar Repair for Excel software.

Summary: Recovering your unsaved Excel file on Windows 10 with some of our tested methods can truly save you a lot of time, money, and effort. Here’s how to do it!

Microsoft provides a wide range of applications to its users that cater to different purposes. Out of all the MS Office applications, Excel is considered the most used native application by several companies and individuals to store and process crucial data. Excel can also be called a go-to data analysis tool that offers great reliability, ease of use, and multiple features. But unfortunately, it’s not immune to human errors and system errors.

What if you accidentally close the Excel file without saving your work or Excel crashes suddenly? Or worse! Your system crashes without any warning and when you reboot your system, you can’t find the unsaved Excel file.

There could be different situations where you may lose access to your unsaved Excel workbook. There is no need to be anxious, though! We’ve covered some easy-to-follow DIY methods in this post to help you recover unsaved Excel files quickly.

4 Ways to Recover Unsaved Excel File

Irrespective of the circumstances, you can recover unsaved Excel files on Windows 10 using the following methods.

Method 1: Use the Search Option

If you remember the name of the Excel file, try to find it using the Search option. Following these steps:

  • Go to Windows Search Box and type the name of the file.
  • If you find the file there, click Open or Open file location.

choose-open-or-open-file-location-from-Windows-search-box

  • If you click Open file location, it will take you to the exact location of the file, and you’ll be able to regain access to lost/unsaved Excel file easily.

Method 2: Use AutoRecover Feature

Microsoft Excel comes with a built-in AutoRecover feature that saves copies of all open Excel files at a user-definable fixed interval. You can recover the file if you forget to save it and accidentally close it or it closes automatically due to an unexpected system breakdown or power failure. You can follow the given steps to recover unsaved Excel files with the AutoRecover feature:

  • Open a new Excel file and go to File > Options.
  • Then go to Save > Save workbooks.
  • Next, ensure that the ‘Save AutoRecover information every’ and ‘Keep the last autosaved version if I close without saving’ option is already selected.

check-if-the-autorecover-options-for-excel-files-are-selected

  • Now, copy the file path given against the AutoRecover file location.
  • Open the File Explorer, paste the Menu Bar file path there, and hit Enter.
  • The unsaved file will appear with the .xlb extension.
  • Double-click the file and choose Excel from apps to open the .xlb file.

choose-excel-application-to-open-xlb-file

  • Finally, save the file to the desired location.

Method 3: Use the ‘Recover Unsaved Workbooks’ Option

Another way that you can choose is the ‘Recover Unsaved Workbooks’ option. To regain access to your Excel file, follow the given steps:

  • Open an Excel sheet and then go to File > Open.
  • Now, scroll down and click Recover Unsaved Workbooks.

go-to-file-then-open-and-click-recover-unsaved-workbooks

  • The list of unsaved files will show in the Document Recovery pane.
  • Locate the file you lost and double-click on it to open.
  • Finally, right-click on the version of the file you want to restore and click Save As.

unsaved-files-will-show-in-document-recovery-pane

And, save the file to the desired location

Method 4: Restore File with Previous Versions Utility

This feature will help you recover unsaved Excel files when you’ve saved the workbook earlier, but you end up losing access to the file due to an Excel or system crash. It’d help you save the previously saved version of your Excel file. To do so, follow the given steps:

  • Open an Excel file and navigate to File > Info > Manage Versions.

go-to-file-then-info-and-then-manage-versions

  • It will show the previously saved versions. You can choose the one you want to restore and click Save/Save As to store the file with a different name.

Hopefully, this blog has helped you learn how to recover unsaved Excel files. You can try any of the above methods.

FAQ

1. How can I repair a corrupted workbook?

Whenever Excel detects a corrupted workbook while opening, it automatically starts running the File Recovery mode and repairing the file. If the File Recovery mode doesn’t start automatically, you can manually repair the corrupted workbook .

How to Fix Excel File Couldn’t Open in Protected View

Summary: This blog discusses about the Excel error ‘The file couldn’t open in Protected View’ and workarounds to fix the error. If you cannot access the Excel file data, using an Excel file repair tool can help you quickly restore the data to its original state.

Free Download for Windows

Protected View is a feature in Microsoft Excel that opens a file in read-only mode while disabling the editing functions. An Excel file opens in Protected View if the file is from an unsafe location. For example, the file may be opened from an insecure Internet location or downloaded as an Outlook attachment from suspicious senders. In that case, your Excel application won’t let you open the file to protect it against malware or virus attacks.

However, the Protected View feature sometimes prevents an Excel file from opening even if it is from a safe location. Also, opening an Excel file may return an error message ‘file couldn’t open in protected view’.

the file couldn't open in Protected View excel error

You may be able to resolve the issue by closing all the open Excel files, closing the Excel application, and then re-opening the problematic file. But this process can take a significant amount of time as you need to close and re-open the Excel application and the file continuously.

How to Fix the Excel File Couldn’t Open in Protected View Error?

Here are some workarounds to fix the error:

Workaround 1 – Disable the Protected View Settings

Note: Before disabling the protected view settings, ensure you have a reliable antivirus software installed on your computer to safeguard files against malware or virus attacks.

  • Open the Excel file throwing the error, go to File and click the Options tab.
  • From the Options dialog box, go to Trust Center and click on Trust Center Settings.
  • From the Trust Center Settings dialog box, select the Protected View tab.
  • Uncheck the appropriate option under the Protected View section, and then click OK to apply the changes. For instance, uncheck the “Enable Protected View for Outlook attachments” option if the file is a downloaded Outlook attachment.

disable protected view settings

  • Click OK again.

Now try opening the problematic Excel file. If it still doesn’t open, try the following workaround.

Workaround 2 – Repair the Office Installation

Sometimes, corruption in the Office installation may cause Excel to return the ‘file could not open in protected view’ error. So, try repairing your Office installation and check if it solves the problem.

  • Open the Control Panel and click the Uninstall a program option under Programs.
  • Click Uninstall a program under the Programs tab.
  • Right-click the Microsoft Office program you have installed and click the Change button.
  • Select the Repair option and click Continue.

repair office program

Once the repair operation is complete, check if you can open the Excel file without any issue.

Workaround 3 – Install Latest MS Office Updates

Several Excel users have reported about experiencing issues (such as the Protected View issue) on opening an Office document like Excel, Word, or others – after upgrading Windows to a newer version. This problem may occur due to incompatibility between the Office app and the updated Windows version. You can try to fix the problem by upgrading the Office app, and here’s how:

  • Click on the File tab in the Excel file that throws an error.
  • Click the Account tab at the left-hand bottom of the screen.
  • From Office Updates, expand Update Options, and then click Update Now.

office updates

After installing the updates, restart your PC and open the Excel file. If this doesn’t work, use the following workaround.

Workaround 4 – Convert the File and Rename It

Some Excel users resolved the ‘Protected view’ issue by renaming their Excel files. But before that, ensure that the file you are trying to open is saved with .xlsx format. If the file type is .xls, you need to convert it to .xlsx format and then rename it. Before converting the file, save a copy of the original file in the desired location.

If the file type is .xlsx, copy the problematic file. Next, open a blank Excel document and paste the copied file. The file will appear as an icon, double-click on it. If it opens without any error, save it with a different name. Hopefully, reaming the Excel file may help resolve the problem.

Conclusion

There is no fixed solution to resolve the Excel error ‘The file could not open in Protected View’. However, the workarounds discussed in the blog have helped users resolve the ‘Protected View’ issue. Make sure to use the workarounds in the same order as explained in the blog.

If you’re having an issue loading the Excel file data due to the ‘Protected View’ error, consider restoring the data using an Excel file repair tool .

Free Download for Windows

How Do I Repair and Restore Excel File?

When an Excel file turns corrupt, the file might become inaccessible or you might receive errors. You may encounter errors, such as ‘the file is corrupt and cannot be opened,’ ‘Excel found unreadable content in “filename>”,’ ‘Excel cannot open “filename” because the file format or extension is not valid,’ etc.

Common Reasons for Excel File Corruption

There are several reasons that can turn the file corrupt. The most common reason is a damaged hard drive. Other factors that can cause corruption in an Excel file are as follows:

  • System crash or abrupt shutdown of the system while the file is still open
  • Viruses infecting the file with malicious code
  • Bug in the operating system
  • Bad sectors on the drive where the file is stored
  • Large spreadsheets with formulas and other components

Whatever be the reason, if your business is dependent on an Excel file, corruption in the file could hamper your business continuity. Also, you may lose crucial data. In such a situation, you could try to repair the file.

Before We Begin

It is important to identify the root cause behind Excel file corruption. If the problem has occurred due to a faulty hard disk drive, contact your hardware vendor to get it fixed. Also, move the file to another local drive and check if it opens. If nothing works, proceed with the methods discussed below to repair and restore the file.

Methods to Repair and Restore Excel File

Try the following methods to fix corruption in an Excel file and restore it.

Method 1 – Use the Built-in ‘Open and Repair’ Tool

You can use the Excel built-in Open and Repair utility to repair the corrupt file. Follow these steps:

  • Open your Excel application and click on Blank workbook.

blank excel workbook

  • On the blank workbook screen, click on the File tab.

file menu

  • Click Open > Computer > Browse.

select the open option

  • Select the file you want to repair and then click on Open and Repair from the Open dropdown box.

open and repair excel file

  • Click Repair to fix corruption in the Excel file and recover maximum data.

repair or extract excel data

  • If you get the following error message, click Yes to open the file.

excel file format does not match error

  • If clicking Yes opens the file with garbage entries (see the image below), perform Step 1 – 5 and click Extract Data. This will only help you recover data without formulas and values.

excel file with garbage entries

Note: You may also try to recover the data from a corrupted workbook by using the methods suggested by Microsoft .

A better way to repair and restore an Excel file with complete data is to use a specialized Excel file repair tool .

Method 2 – Use Excel File Repair Tool

Stellar Repair for Excel is a powerful tool designed to help users fix corrupted .xls or .xlsx files without any technical assistance. Also, the tool recovers all the components from a corrupted workbook, including tables, pivot tables, cell values, formulas, charts, images, etc. You can preview the repaired file and its contents by downloading the free demo version from the link below. It is a useful feature that allows the user to validate the data before saving it.

[

Free Download For Windows

](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/ “Free Download For Windows”)

Here’s the step-by-step instructions to repair a corrupt Excel file using the software:

  • Run the software. The software main interface opens with an instruction to add some add-ins if you’ve engineering formulas in the file you want to repair.

software main screen

  • Click OK to proceed.

  • Select the file you wish to repair by using the Browse option.

Note: If you’re not aware of the file location, choose the ‘Search’ option to locate the file.

repair excel file

  • A screen showing progress of the Excel file repair process is displayed.

progress of the repair process

  • Preview of the repaired Excel file and its recoverable data is displayed.

preview repaired excel file

  • After verifying the data, click on the Save File button on the File menu to save the repaired file.

save repaired excel file

  • Select the location where you wish to save the repaired file on the Save File window and then click OK.

save at default location

A confirmation message will pop-up after completion of the repair process. You can now try to open the file in your Excel program.

End Note

Even if you’re taking preventive measures, you might still experience corruption in an Excel file. So, it’s crucial to take regular backups of your workbooks. For this, ensure that the ‘Always create backup’ option is enabled in Excel. You can find it in General Options by clicking on the Tools button in the Save As dialog box. Enabling it will ensure that the Excel backup file is updated with the changes made in a spreadsheet.

Additionally, ensure that the Excel ‘AutoRecover’ feature is set to save a version of your Excel file after every 10 minutes. You can increase or shorten the interval as per your requirement.

How to fix Microsoft Excel has stopped working error?

Summary: This blog discusses the possible reasons behind ‘Microsoft Excel has stopped working’ error and solutions to resolve the error manually. You can use Stellar Repair for Excel to quickly repair the file and recover all its data in a hassle-free manner.

Free Download for Windows

Has your Microsoft Excel program stopped working or is acting strange? Excel not responding is a common issue you may experience on launching the application or opening a spreadsheet.

Microsoft Excel has stopped working

Figure 1 – Microsoft Excel Has Stopped Working Error Message

Possible Causes behind ‘Microsoft Excel has Stopped Working’ Error, and Solutions Thereof

Note: Several users have reported about encountering the ‘Excel has stopped working’ issue on Windows 10, 8, and 7 OS after installing an update for Excel (KB3118373). If you too have installed the update, then uninstall it and check if it solves the error. For detailed information, refer to this link .

[Fixed] “Microsoft Excel Cannot Access the File” Error

Summary: The “Microsoft Excel cannot access the file” error usually occurs when there is an issue with the Excel file you are trying to save. This post summarizes the causes behind the error and mentions some effective solutions to fix it. If you suspect the problem is encountered due to corruption in the Excel file, you can use the professional Excel repair tool mentioned in the post to repair the file.

Free Download for Windows

You may experience the “Microsoft Excel cannot access the file” error when saving the Excel file. This happens when the Excel application fails to read the file you are attempting to save. The error message indicates that there is an issue with the file name or its path. Sometimes, the error occurs if the file you are trying to access is already in use by another application. Some other reasons for the “Excel cannot access the file” error are:

  • Faulty or incompatible Excel add-ins.
  • The file is in Protected View.
  • The Excel file is damaged or corrupted.
  • You do not have the required permissions to access the file.
  • The Excel file is not in a compatible format.

Methods to Fix “Microsoft Excel Cannot Access the File” Error

Sometimes, changing the file location can fix the “Microsoft Excel cannot access the file” error. You can try changing the file location, if the location is incorrect. If moving the file to a different location didn’t work, then try the below troubleshooting methods.

Method 1: Check the File Name and Path

You can get the “Microsoft Excel cannot access file” error if there is an issue with the file path – either the path does not exist or it is too lengthy, thus creating conflicts. Make sure the file path is correct. If the file name is too long, you can rename the file with a short name and also move the file to the parent folder instead of a subfolder. After that, remove the file from the Recent list that is created by Excel based on your recent activity. Follow the below steps:

  • Open the Excel application.
  • In the Recent list, right-click on the affected Excel file.
  • Now, select Remove from list.

Selecting the "remove from list" option

  • Close the Excel application.

Now, reopen the problematic file and check if the error exists. If yes, then follow the next solution.

Method 2: Try Clearing the Microsoft Office Cache

Sometimes, clearing the Microsoft Office cache can help eliminate the “Excel cannot access the file” error. To clear the Microsoft Office cache, follow the given steps:

  • First, close all the Office applications.
  • Press Windows+R to open the Run window.
  • Type %localappdata%\Microsoft\Office\16.0\OfficeFileCache and press the Enter key. You can change ‘16.0’ with your Office version.

Clearing Microsoft Cache from officefilecache Window

  • In the OfficeFileCache window, clear all the temporary files.

Method 3: Check and Update Microsoft Excel

You can try updating your Microsoft Excel application. The latest updates include bug fixes, security patches, and other improvements. Updating the application can help fix several issues that might be causing the error. Here are the steps to update Microsoft Excel:

  • Open your Excel application.
  • Go to File and then select Account.
  • Under Product information, click Update Options and then click Update Now.

Method 4: Disable Protected View

You may get the “Microsoft Excel cannot access the file” error if the Protected View option is enabled. You can try disabling the Protected View settings in Excel. This allows you to open the file without any restrictions. However, disabling the protected view can put your system at high risk. To disable the Protected View in Microsoft Excel, follow the below steps:

  • In Excel, go to File and then click Options.
  • In the Excel Options window, click Trust Center and then click Trust Center Settings.

Go To Trust Center and Click on Trust Center Settings

  • Click Protected View from the left pane in the Trust Center Settings window.
  • Unselect the options under Protected View. Click OK.

Method 5: Check and Disable Add-ins

The “Excel cannot access the file” error can also occur due to faulty add-ins in Excel. To check if the error has occurred due to some faulty add-ins, open the application in safe mode (press Windows + R and typeexcel /safe in the Run window**)**. If you can save the file without any hiccups in safe mode, this indicates some problematic add-ins are behind the error. You can remove the Excel add-ins by following these steps:

  • Open your Excel application and go to File > Options.

  • In Excel Options, select Trust Center and then click Trust Center Settings.

  • In Trust Center Settings, click Add-ins and thenselect “Disable all applications Add-ins”. Click OK.

Go to 'Add ins' and select disable all application add ins

Method 6: Check File Permission

You can get the “Excel cannot access the file” error if you don’t have sufficient permissions to modify the Excel file. You can check and provide the write permissions to fix the issue. Here’s how to do so:

  • Open Windows Explorer.
  • Find the affected Excel file, right-click on it, and click Properties.

Click Properties Option

  • In the Properties window, click the Securities option and click Edit.

Go to Security and then click Edit option

  • In the Security window, select the user names under ‘Group or users name’.
  • Check the file permissions and make sure the write option is enabled. If not, then grant the permission. Click Apply and then OK.

The “Excel cannot access the file” error can also occur due to broken external links in the Excel file. External links are references to the data or content in other files. The link usually breaks if the file has been moved to another location or the file name is changed. You can check and change the source of link.

Method 8: Repair your Excel File

Excel may fail to read the file if it is corrupted or damaged. If the error “Excel cannot access the file” has occurred due to file corruption, then try the Excel’s Open and Repair utility to repair the Excel file. Here are the steps:

  • In the Excel application, click the File tab and then select Open.
  • Click Browse to select the problematic workbook.
  • The Open dialog box will appear. Click on the corrupted file.
  • Click the arrow next to the Open button and then select Open and Repair.
  • You will see a dialog box with three buttons – Repair, Extract Data, and Cancel.

Click repair option

  • Click on the Repair button to recover as much of the data as possible.
  • After repair, a message is displayed. Click Close.

If the Open and Repair utility fails to work , it indicates the Excel file is severely corrupted. Use Stellar Repair for Excel to repair severely corrupt Excel file. It helps recover all the components of the corrupted Excel file, such as charts, formulas, etc. without making any changes to the original file. It can also fix all types of corruption-related errors. You can use Stellar Repair for Excel to repair Excel files created in all Excel versions – from 2007 to 2023.

Closure

The “Microsoft Excel cannot access the file” error can occur due to numerous reasons. Follow the troubleshooting methods, such as checking file location, path, permissions, etc., as discussed above to fix this error. Sometimes, Excel throws this error if the file you are trying to save is corrupted. You can try repairing the file using the built-in utility – Open and Repair. If the file is severely corrupted, then you can use Stellar Repair for Excel . It can repair damaged Excel files (.xls, .xlsx, .xltm, .xltx, and .xlsm) with complete integrity.


  • Title: Fixed Microsoft Excel 2000 Cannot Access the File Error | Stellar
  • Author: Nova
  • Created at : 2024-03-13 17:10:36
  • Updated at : 2024-03-14 10:47:42
  • Link: https://phone-solutions.techidaily.com/fixed-microsoft-excel-2000-cannot-access-the-file-error-stellar-by-stellar-guide/
  • License: This work is licensed under CC BY-NC-SA 4.0.
On this page
Fixed Microsoft Excel 2000 Cannot Access the File Error | Stellar