Excel Data Source error

Question

Hello,

Getting these errors all of a sudden in excel with numerous spreadsheets:  Excel 2013

1. The following system error occurred. The requested name is invalid, but no data of the requested type was found. (OK)

2.  The Wizard will help you connect to the Analysis Services data source. (PAX-####)  Enter userid and password.

3. An operation that uses the database drive could not be completed.  If the driver is a Microsoft driver, make sure the driver file isn't damaged and if it is, reinstall the driver by reinstalling Microsoft Query.  For other drivers, contact your database administrator or driver vendor.

Any help, will be greatly appreciated.

Thank you.

Answer 1

Your query needs to be posted on our TechNet forum for better assistance. We have members who will be able that would help you with this Excel issue Here's the link.

If you have other questions or concerns in the future, we're just a click away.

Answer 2

Here are the images:

Answer 3

• Did you notice any changes on the computer prior to this concern?      No
• What troubleshooting steps have you tried so far?                                 Just tried to restart Excel
• Can you send us a screenshot of the error message that you are getting in Excel? Make sure that you remove all personal information.   Screen shots below.

Screen shots:

Answer 4

Hi,

There are several reasons why you are experiencing this problem and that's what we are going to figure out. This type of issue normally happens when there's a software change made on the computer prior to this concern. Before we proceed with the troubleshooting steps, we would like to know more about this concern. Kindly answer the questions below:

• Did you notice any changes on the computer prior to this concern?
• What troubleshooting steps have you tried so far?
• Can you send us a screenshot of the error message that you are getting in Excel? Make sure that you remove all personal information.