Microsoft Excel cannot access the file? Use These Solutions

Excel cannot access some files that are damaged or corrupted

by Teodor Nechita
Teodor Nechita
Teodor Nechita
Software Managing Editor
Eager to help those in need, Teodor writes articles daily on subjects regarding Windows, Xbox, and all things tech-related. When not working, you may usually find him either... read more
Affiliate Disclosure
  • Make sure all the external links in the workbook are valid and update them if modified, or delete them if they cannot be found anymore.
  • Installing the latest updates for Microsoft Excel and disabling add-ins can fix the error message.

Microsoft Excel is a major component of the Microsoft Office Suite and acts as the official spreadsheet software.

Because of this, there isn’t a person alive that hasn’t used or at least heard of Microsoft Excel. However, it is just a program after all, and no program is safe from the occasional issues and bugs.

Such would be the case with an error message some users have been reporting, where Microsoft Excel states that it cannot access a file.

I have a large Excel 2013 file that I’m modifying. When I open the workbook I receive errors […]
Microsoft Excel cannot access the file…

What can I do if Microsoft Excel cannot access any file?

This error usually occurs when you press an external link within a workbook, but the name or the file path of the linked item has been changed.

This leads to the error message described above. Because of this, there are only a couple of things that you can do to remedy this problem:

  • Make sure that the linked items are not moved or renamed
  • Make sure the linked items are updated within the workbook if modified
  • Delete the linked items if they cannot be found anymore

Finding all the external links within a workbook can be a daunting task, especially if the workbook spans several pages and hundreds of cells.

Because of this, one simple solution to finding them is to find links used in formulas:

  1. Open Microsoft Excel
  2. Press Ctrl + F
  3. Click Options
  4. Enter .xl In the Find what box
  5. In the Within box, click Workbook
  6. In the Look in box, click Formulas
  7. Click Find All
microsoft excel cannot access the file find links

This will bring all the external links to other workbooks together, and from here you can update them all.

2. Install the latest updates for Microsoft Excel

  1. Open Microsoft Excel
  2. Click on File
  3. Click Account
  4. Select Update Options
  5. Select Update Now
  6. Let the updates run their course

3. Disable add-ins

  1. Open the Excel sheet
  2. Go to the File menu
  3. Click on Options
  4. Click on Add-ins
  5. Select Excel add-ins and click on the Go button
  6. Uncheck all boxes and click OK

By following these steps, you should be able to get rid of the error message in Microsoft Excel.

Know of any other solutions to this common Microsoft Excel problem? Let us know in the comments section below!


This article covers:Topics: