When BI is installed it is set by default to only show basic functions. This means that you are limited to what you are able to achieve.

To enable full functionality select ‘Personalise’ from the Sage BI Toolbar.

Select Advanced functionality within the following screen

N.B. The changes will only take effect when Excel is relaunched.