I was wondering if anyone is familiar with connecting to cubes through Excel 2007.  I am able to see the cube, but when I reach the part where the data is supposed to be imported, I am getting the following errors:

"An error has occured in teh transport layer."

"Errors in the OLE DB provider.  An error occurred while loading the connection dialog box components for promting."

I think that the issue is not with the cubes.  All my reports in Reporting Services are working just fine.  Thank you for any help! 

Thanks,

- John M.

I would reinstall Analysis Services 9.0 OLEDB Provider, this is available as a seperate install from the MS download site.

good luck