The update interval applies to all read functions in the workbook.
If multiple workbooks are open, you must define the update interval for each one with the same value.
To determine whether an update interval named range has already been defined, select the Home tab. In the Editing group, click Find & Select → Go To and select DVUpdateInterval.