TM1RESOLVESHEET

TM1RESOLVESHEET resolves formulas with nested parentheses in an active worksheet. Make sure you are not connected to a server when running this function.

The function removes nested parentheses from formulas in each cell in an active worksheet and returns OK or UNRESOLVED.

Note: TM1RESOLVESHEET does not remove nested parentheses from cells that contain compound formulas. Those cells remain unchanged.

Syntax

TM1RESOLVESHEET( )