Skip to content
logo Knowledgebase

ERROR: '[08001] Cannot find all files in the data path'

Created on  | Last modified on 

Summary

How to fix the error in Sage 50 Excel reports.

Description

Microsoft’s April 2024 Excel update hides Microsoft Query under Legacy options. This results in the error when you use Excel with Sage 50 Accounts.

Resolution

To resolve this, you'll need to turn Microsoft Query back on:

  1. Go to Microsoft Excel.
  2. Go to File then select Options.
  3. Select Data.
  4. In the Show legacy data import wizards section, tick From Microsoft Query (Legacy) then select OK.

Data options menu.

  1. Go to Data, select Get Data, select Legacy Wizards, then select From Microsoft Query (legacy).
  2. Close and reopen Microsoft Excel.
  3. Go to the Data tab at the top of Excel then select Get Data.
  4. Select Legacy Wizards then select From Microsoft Query (legacy).

If the issue persists

  1. Link to your data in Microsoft Excel using ODBC.

    NOTE:

    If the issue persists after following all the steps in this article, we recommend contacting your IT provider to review your environment.