Refresh data in a PivotTable or PivotChart report

Microsoft Office Excel 2003

  • Click the report.
  • On the PivotTable toolbar, click Refresh Data Button image.
  • If you want Microsoft Excel to refresh the report automatically when you open the workbook, set this option.

    ShowHow?

    1. On the PivotTable toolbar, click PivotTable or PivotChart, and then click Table Options or Options.
    2. Select the Refresh on open check box.
    Security Note   Setting this option can pose as a security risk as arbitrary SQL scripts can be executed upon automatic refreshing of reports.
  • If the report is based on external data, and you want Excel to refresh it at timed intervals, set this option.

    ShowHow?

    1. On the PivotTable toolbar, click PivotTable or PivotChart, and then click Table Options or Options.
    2. Select the Refresh every check box, and then enter the interval you want in the minutes box.
  • Note  When you refresh a PivotChart report or its associated PivotTable report, some chart formatting may be lost.

    ShowTip

    If your database prompts for a password every time you refresh, you can have Excel save the password so you won't have to enter it repeatedly. On the PivotTable toolbar, click PivotTable or PivotChart, click Table Options or Options, and then select the Save password check box. This option saves the password as readable text, so if security is a greater concern than convenience, you may not want to use this option.