While opening the Active Sheets in TM1 Pax, i have noticed that Cognos_Office_Connection_Cache worksheet is also created: open VBA then can notify the Cognos_Office_Connection_Cache worksheet. But I would like to remove this before saving the reports.
I have tried with Automation CognosOfficeAutomationObject.ClearCache() but no effect.
Any suggestion???