Make Better Decisions

QMetrix provides enterprise budgeting & forecasting, analytics and data management services.
By leveraging proven technology through fixed price engagements, QMetrix removes the risk, whilst your business reaps the reward.

Your journey to better insights, starts here

CONTACT US

Often when running Cognos reports and trying to export it into Excel a problem or issue occurs where the browser settings in IE (Internet Explorer) blocks or disables the export functionality. Please see the tips below to verify your browser settings to enable successful Excel exports.

Tip 1:
In some instances the export has actually worked, but the usual download popup window does not appear. The first area to check is your recently downloaded files as seen below in the View Downloads menu:
Export Excel 1

Tip 2:
Another browser setting to check is the pop-up blocker, which can be disabled in the Internet Options -> Privacy tab.
Export Excel 2
Tip 3:
If by this point the Excel export is still not working, please check that downloads are actually enabled. To do this open Internet Options, click on the Security tab, select Local Intranet and click Custom level. A new window will pop up, scroll down to Downloads area and verify that it is set to Enabled. You may need to repeat this step for Trusted Sites, however please see tip 4 before doing so.

Export Excel 3 Export Excel 5

Tip 4:
In some instances the Cognos server may need to be added to the Trusted Sites list. Open Internet Options, click on the Security tab, select Trusted Sites and click the Sites button. Enter the URL of the Cognos server and click Add (you may need to uncheck the https: requirement first).
Export Excel 4
Export Excel 6