Save Reports from Microsoft Excel

If you click on the Office Button/Save As in Microsoft Excel 2007, the report will be saved as an IBM® Cognos® Controller Link for Microsoft Excel spreadsheet.

An Controller Link spreadsheet is updated by pressing the F10 key while the entire workbook is updated by pressing F9.

Changes made to the layout in an IBM Cognos Controller Link for Microsoft Excel spreadsheet will not be saved in the IBM Controller Report Generator. Once an IBM Cognos Controller Link for Microsoft Excel spreadsheet is created its connection to the Controller Report Generator is cut. The original report will still remain in IBM Cognos Controller.