Data Spreading Applies Across Multiple Populated Ranges
In the previous example, when you initiate data
spreading from a single cell, spreading is applied to any cells that
contain DBRW functions in the specified direction.
Note: Be careful when you spread data in a worksheet that contains
multiple ranges with DBRW functions, and retrieve values from the
same cube.
For instance, the following example shows two ranges populated with DBRW functions: range B6:D9 and range H6:J9. Both ranges retrieve values from PriceCube.
If you initiate the Repeat data spreading method from the selected cell, specify the value 99, and extend the spreading Right, data is spread to all cells to the right of the selected cell.
You can work around this issue by applying data spreading only to a selected range when a worksheet contains multiple ranges populated with DBRW functions. Using the previous example, you would select the range B8:D8 and then apply the data spreading to restrict the spreading operation to the selected cells.