TM1RESOLVEFORMULAS

Use TM1RESOLVEFORMULAS to resolve formulas with nested parentheses in a cell range.

The TM1RESOLVEFORMULAS function removes nested parentheses and returns OK or UNRESOLVED. When you run the function, formulas in the given cell range in the active workbook resolve.

Note: Make sure you are not connected to TM1 when running this function and that you run the function in manual calculation mode for optimal performance.

Syntax

TM1RESOLVEFORMULAS(string range)

Example

TM1RESOLVEFORMULAS("C3:B9")