Follow these instructions to allow Business Objects reports to be exported to Excel with no issues

While in Internet Explorer, Click Tools and select Internet Options.

Select The Security Tab.
Then select Custom Level.

Scroll down to the Download area which is a little under half way down and choose Enable on the “Automatic prompting for file downloads”.
Click Ok
Click Apply.