Update Data

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

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

Procedure

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

The function keys F9 (refresh workbook) and F10 (refresh worksheet) also serves as Refresh if you are logged on to 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 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.