We recently upgraded from 8.5
This issue is occuring when we export to excel from the Trial Balance w/Drilldown window. I haven't tested this issue from any other form yet.
We click on 'Send to Application' and it opens the report into a new instance of Excel. Click on 'Send to Applications' again, and you get a third instance, and so on. I verified this by looking in the windows task manager.
This is an issue for us because we have created several macros to format the reports for printing. They are saved in an Excel Add-in or in the 'Personal Macro Workbook' file. These do not get loaded automatically when the new instances are created.
Does anyone know how to correct this issue? My IT department tells me that is 'expected functionality'. I say they are just lazy.
Pinned topic Send to Application creates multiple instances of Excel
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-10-10T14:07:59Z at 2012-10-10T14:07:59Z by davper
davper 270005MSH93 Posts
Re: Send to Application creates multiple instances of Excel2012-10-10T14:07:59ZThis is the accepted answer. This is the accepted answer.I just noticed that the Cognos Controller Excel Link Add-in does not get loaded. I tried manually adding, but Excel thinks it is already added.