Excel and Analysis Services Cubes

M

MikeD

With Excel and MSAS 2000, I could share cube spreadsheets with other users -
the users could run the spreadsheets and do a refresh without problems. Since
upgrading to MSAS 2008, Excel gives the error "An error was encountered in
the
transport layer". This error then triggers another error "Errors in the OLE
DB provider. An error occurred while loading the connection dialog box
component for prompting". Only the original author can refresh the
spreadsheet against the cubes, nobody else (even if the data connection name
is the same). Is there a solution to this issue? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cannot connect to SQL 2000 AS SP 3 cube from Excel 2000 1
Excel Error while connecting to OLAP cube 0
How to get data from Analysis Services cubes into Access 18
Excel Service error "cannot connect to external data source" 1
querying a cube 0
How do I configure Analysis Services for Excel 2003 users? 1
Excel application cannot access SSAS cube over MOSS 2007 over inte 0
connecting to an olap cube outside the intranet 4

Top