PivotExportToExcel disappears in Runtime

Nov 13, 2009
Reaction score
I'm developing an Access 2007 program which will have a pivot form in it. While developing, I noticed the Export to Excel button, which I wish to incorporate into the final product. I've been able to create a customized ribbon containing the PivotExportToExcel control. And when I run the program in Access, it works great.

The problem is, when I create a package and deploy it, the ribbon tab containing that control is empty. As a test, I've change the control to a basic Paste button, and it was there. But for PivotExportToExcel, it did not come accross in the package.

Here's my XML that is in the USysRibbons table.

<customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui">
<ribbon startFromScratch="false">
<tab id="dbCustomTab" label="A Custom Tab" visible="true">
<group id="dbCustomGroup" label="A Custom Group">
<control idMso="PivotExportToExcel" label="ExportToExcel" enabled="true"/>

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question