Excel 2007 - Report and Design buttons are missing or Run-Time error 91.
This is often caused by both the jetreports.xla and jetreports.xlam being active at the same time.
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.