E10: XL Connect DrillDown function

Hi all,

Could someone help me understand how to get the drilldown to work in XL Connect?..When I right click the mouse, sometimes the drilldown button is greyed out and other times it does not work at all.

Thanks

What version of XL Connect are you using?

Minor Version 9.0.0.5 SP6

I am using it in conjunction with Excel 2010