Extreme speed does not support multiple-area references such as (A1:A5,B1,C1:E1) except as used in standard functions such as SUM that accept a variable-length argument list of cell ranges. The only supported use of the comma is as the separator in the argument list of a standard function, not as a cell-range union operator. A defined name whose value is a multiple-area reference is not accepted:
Example message: "Multi-area reference not supported at cell location [Book1.xls]Sheet1!A1. (Code #5525)"
Workaround: For best results, avoid using multiple-area references when defining names or as arguments to any functions except those that accept a variable-length, comma-separated list of cell ranges.