Importing data from Excel Workbook

[excalibur19]

Hello all,

I am trying to create a new pivot table in PowerPivot which will pull data from an existing excel workbook (locally stored on my computer). But when I try to import data, below is the error message I get:

============================
Error Message:
============================


Cannot connect to the data source because the Excel provider is not installed.


============================
Call Stack:
============================


at Microsoft.AnalysisServices.Common.DataSourceBasic.ValidateProviderInformation()
at Microsoft.AnalysisServices.Common.DataSourceBasic.TestConnection()
at Microsoft.AnalysisServices.Common.DataSourceBasic.ClickTestConnection(Object progressControl)


============================


The reason I am doing this is because the excel file which I am trying to import is updated every week and I don't want to create my pivot table and pivot charts every week after the update. I'd rather create a file which links to the data and refresh it every time there is an update. (The updates will be done manually where I'd get the file from the server and replace the existing copy with the new file. At some point in future, I'd like to reference the server file directly, once I get a hang of PowerPivot!)

I have Excel 2010 (32 Bit) with .NET 4.0.30319 installed. Below are the steps I am following:

1. Open a blank excel workbook and open the PowerPivot window
2. In the section "Get External Data" in the toolbar at the top, click on "From Other Sources"
3. Select "Excel File" from the list and click next
4. In "Excel File Path", specify the file path for the source file located on my computer
5. Click on "Test Connection" and get the error


I'd appreciate any help I can get! Thanks in advance for your time and efforts.