Microsoft Excel can’t access a file? Follow these easy steps

Teodor Nechita
by Teodor Nechita
Software Managing Editor
Affiliate Disclosure

microsoft excel can't access the file
To fix various PC problems, we recommend Restoro PC Repair Tool: This software will repair common computer errors, protect you from file loss, malware, hardware failure and optimize your PC for maximum performance. Fix PC issues and remove viruses now in 3 easy steps:
  1. Download Restoro PC Repair Tool that comes with Patented Technologies (patent available here).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues affecting your computer's security and performance
  • Restoro has been downloaded by 0 readers this month.

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?

1. Make sure all the external links in the workbook are valid.

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!

RELATED ARTICLES YOU SHOULD CHECK OUT:

idee restoro Still having issues? Fix them with this tool:
  1. Download this PC Repair Tool rated Great on TrustPilot.com (download starts on this page).
  2. Click Start Scan to find Windows issues that could be causing PC problems.
  3. Click Repair All to fix issues with Patented Technologies (Exclusive Discount for our readers).
Restoro has been downloaded by 0 readers this month.
This article covers:Topics:

There are no comments yet. Please leave a comment

add a comment

Leave a Reply

Your email address will not be published. Required fields are marked *