Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adandreamohr
Starting Member
1 Post |
 Posted - 2007-01-18 : 14:43:30
|
| Hi,I've created a couple of cubes in AS and some Excel spreadsheets, some with standard pivot tables and others with reports created with the Excel Add-In for Analysis Services.The part I'm having problems with is that when I distribute the excel files, the receipients don't have the MS Query connections defined in their machines and hence they can't refresh or filter the reports.I tried having people copy the .oqy files (for standard pivot tables) and also the .odc files (for the Excel Add-in) to their hard drives but users still can't refresh data. Could it be a credentials problem? Is there a better way to distribute the excel files without distributing the .odc and .oqy?Thanks in advance,Ale |
|
|
|
|
|
Excel pivot tables from Analysis Services - Questi