Excel 2007 - Report and Design buttons are missing or Run-Time error 91
This information applies to Jet version 2013 U1 and older
Symptom
When using older versions of the Jet Excel add-in with Excel 2007, the Report and Design buttons are missing or Run-Time error 91 is displayed. Cause This is often caused by both the jetreports.xla add-in and the jetreports.xlam add-in being active at the same time.
Resolution
You can only have one of them active at a time.
- Go to the "Office Button"
- Select Options then Add-ins,
- Select the Add-in Manager
You will see both add-ins.
For Excel 2007, you should only have the jetreports.xlam active, so uncheck the jetreports.xla.
After making the necessary changes, restart Excel.