I have created a custom shortcut menu for my pivot charts so that only the


drilldown/drill out/expand/collapse menus are available when viewing a pivot.
This menu works fine when I open up a form directly as a pivot chart.

However I have then placed this pivot chart as a subform on my main form I
use to display various charts. For some reason though when I right click to
drill down etc all of the options are greyed out.

This seems really weird because if i re-enable the default menu that has all
of these options + properties + field list etc the options are not greyed out
and work correctly. I can only assume there is some weird focus issue or a
value not being passed correclty?

I have included screen shots of the issue:

http://img814.imageshack.us/img814/945/notworking.jpg

http://img227.imageshack.us/img227/4914/setupe.jpg

http://img197.imageshack.us/img197/6040/workinga.jpg