Different Methods of Updating a Microsoft Excel Report

Pressing F9 will refresh all worksheets in a workbook. Perform the following steps if you want to view the first and the second worksheet without processing other values. This will make the updating process more efficient:

If you want to view all the worksheets, press F10 every time you open a worksheet. This will speed up the process of fetching values from the database.

Note: Pressing F10 will update the current worksheet and all other worksheets that are referenced by it. If you experience slow performance, try to replace references to the fGetVal functions on other worksheets with the actual fGetVal function.

Procedure

  1. Open a Microsoft Excel report, select the first worksheet and press F10. This method is fast and will refresh this worksheet only.
  2. After looking at the values, select the second worksheet and press F10. This will refresh this worksheet only.
  3. Close the workbook.