Refresh data on Excel recalculation Keys (F9, Shift F9)

This setting enables Custom Report refreshes by using Microsoft Excel recalculation keys.

About this task

Use this setting to enable Custom Report refreshes by using Microsoft Excel recalculation keys. When this setting is enabled, you can use F9 to refresh the entire workbook or Shift + F9 to refresh the current sheet.

Note: You need to restart Microsoft Excel after setting this option for it to take effect.

Procedure

  1. On the IBM® Planning Analytics tab, click Options Options icon.
  2. In the navigation pane, click IBM Planning Analytics.
  3. Locate Refresh data on Excel recalculation Keys (F9, Shift F9) under Custom report settings.
  4. Select the check box.
  5. Click OK.