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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-12-18 : 06:24:55
|
| HiI have Excel 2003 (or is it 2002....anyway it's one of these) and need a little guidance regarding how to make a connection to my cube.I tried the Pivot Wizard but do not see any option which allows me to connect to my cube.Kindly assist.Thanks & Regards.-J |
|
|
stevefromoz
Starting Member
2 Posts |
Posted - 2005-01-07 : 01:23:41
|
| Did you get this sorted?? If you go to (menus) Data|Import External Data|New Database Query and then in the dialog go to the 'OLAP Cubes' tab, then dbl-click <new connection>, the rest should be ok from there. |
 |
|
|
Joozh
Posting Yak Master
145 Posts |
Posted - 2005-01-07 : 01:25:19
|
| Thanks :) |
|
|
|
|
|
|
How to connect to a cube using Excel 2003/2003?