Mark,
XLCubed works in excel 97 upwards and has an explorer mode which will
do simple lists which retails at 99 US dollars per seat for 10 seats
and above. Explorer does not have the functionality of the full
product but does do drill down, pivoting and drillthough so should do
more than what you want.

Alternatively, here is a link to some VBA code that John Keeley posted
sometime ago which will dump an MDX query into excel .. not tried in
97 but I see no reason why it would not work if you want to roll your
own app.


http://groups.google.com/groups?q=Ke... le.com&rnum=1

Hope this helps.

Cheers

Mark Scanlon
XLCubed
http:\\www.xlcubed.com



"Mark" <Mark (AT) discussions (DOT) microsoft.com> wrote