Extreme speed does not support dynamic ranges, where the OFFSET function is used on one or both sides of the range constructor. For example, =AVERAGE(Cellname1:OFFSET(Cellname2, x, y)).
Example message: "Unable to interpret formula at cell location [Book1.xls]Sheet1!A1. (Code #5504 - Invalid token)"
Workaround: Avoid using the OFFSET function to construct dynamic ranges.