Update Data

You need to update the workbook if changes have been made in IBM® Cognos Controller since the last time you used the IBM Cognos® Controller Link for Microsoft Excel.

When you open an existing workbook, the IBM Cognos Controller Link for Microsoft Excel shows the data last saved for the current workbook, not the data from the buffer memory or from the Cognos Controller database. The same applies if changes are made in Cognos Controller while you are logged on to the IBM Cognos Controller Link for Microsoft Excel.

Procedure

On the Controller menu, click Refresh to update the data in the IBM Cognos Controller Link for Microsoft Excel report (workbook) with the latest changes in Cognos Controller.

The function keys F9 (refresh workbook) and F10 (refresh worksheet) also serves as Refresh if you are logged on to Cognos Controller. Otherwise it functions as usual in Microsoft Excel. The report will display 0 for all functions for which it does not find any values.

The Refresh Functions (F9) and (F10) only works for the IBM Cognos Controller Link for Microsoft Excel. If you want to refresh a report created in Reports/Create, you have to choose Reports/Run Report to update the data.