Child pages
  • KB170046735: WebCenter - How to force Saved Search Results Excel sheets to update upon opening (Saved Search Templates)
Skip to end of metadata
Go to start of metadata

 

Description

Results of Saved Searches can be saved into Excel sheets using a predefined template (see: Upload Saved Search Results Template). By default, when creating an Excel template sheet, values are not automatically updated. 

Example: I have created a series of Task Saved Searches for which I have created an Excel template to download the search results into. I have two additional worksheets in the xlsx file that perform some basic math on the search results data. I can upload the template and download the results, but the formulas on the additional worksheets will not update with values from the Search Results worksheet without forcing a manual update

This article describes how to automatically update values.

Procedure

To automatically refresh data when a workbook is opened:

  1. Click any cell in the external data range.

  2. On the main menu's Data tab > Connections group, click the arrow next to Refresh and then choose Connection Properties.

    Excel Ribbon Image

  3. Go to the Usage tab.

  4. Under Refresh control, enable the Refresh data when opening the file check box.

To automatically refresh data in a PivotTable:

  1. Right click on your PivotTable.
  2. Choose PivotTable Options... from the contextual menu.
  3. Open the Data tab.
  4. Enable Refresh data when opening the file.
Article information
Applies to

WebCenter all versions

Created15-May-15
Last revised 
AuthorJORY
CW Number 
Contents