Data Refresh Changes in Connected Datasets and Workbooks
You can change the response mode to Cached Response or Real-time Response in several ways:
Changing the response mode from a dataset
When you change the response mode from the dataset, the mode changes for the workbook if your workbook uses one dataset only. If your workbook uses more than one dataset, you must change the response mode in all linked datasets first. See the following example with the same workbooks and datasets:
-
Example a: Workbook 1a uses Dataset 1a.
-
Example b: Workbook 1b uses Dataset 1b and Dataset 2b.
In the first example, when you enable the mode from Dataset 1a, the mode for Workbook 1a is also enabled. However, when you enable the mode from Dataset 1b, the mode for Workbook 1b does not change. You must enable the mode in both datasets first, Dataset 1b and Dataset 2b. Then, the mode is also enabled for Workbook 1b.
For more information about how to work with Cached Response mode, see Working with Cached Response Mode.
Changing the response mode from a workbook
When you change the response mode from your workbook, the mode is also enabled for all linked datasets that your workbook uses. See the following examples:
-
Example a: Workbook 1a uses Dataset 1a.
-
Example b: Workbook 1b uses Dataset 1b and Dataset 2b.
In the first example, when you enable the mode from Workbook 1a, the mode is also enabled for Dataset 1a. In the second example, when you enable the mode for Workbook 1b, the mode also changes for both datasets, Dataset 1b and Dataset 2b.