- You open a Microsoft PowerPivot workbook that is authored on a different computer on your system.
- In the PowerPivot window, you try to update the data with the most current data from the back-end server by using the Refresh All option in theRefresh menu. Or, you try to import data by using one of the connections under theExisting Connection option in the Design tab.
In this scenario, you may receive an error message that resembles the following:
- The provider <Provider name> is not registered.
- The following system error occurred: Class not registered A connection could not be made to the data source with the DataSourceID of <data source id>', Name of <data source name>. An error occurred while processing the <table name>. The provider <Provider name> is not registered.
- The operation has been cancelled.
Note The error may be repeated for each connection that fails.
This behavior is by design.
Procedure 1: Configure the failing connection to use a different and compatible provider that exists on your system
To do this, follow these steps:
- In the Power Pivot Window, click theDesign tab in the ribbon menu.
- ClickExisting Connections.
- From the list of available connections, click the connection that is failing, and then clickEdit.
- In theEdit Connection window, click Advanced.
- In theSet Advanced Properties area, change the Provider value to a different and compatible provider, and then update the data.
For example, if the connection is configured to use SQLNCLI10 (SQL Native Client 10 Provider), and if SQL Native client is not installed on your system, change the provider to SQLOLEDB, and then update the data in the workbook.
Procedure 2: Install the provider
- Identify the provider that is used for the failing connection. To do this, use the information in the error message or the steps that are documented in Procedure 1 to identify the provider.
- Install that provider on your system by using the installation media or by downloading the provider from the Internet.