Extract Microsoft Excel Formulas

When you filter a Microsoft Excel spreadsheet, KeyView extracts the value of each cell. The value of a cell might be calculated from a formula, but the formula is not included in the output unless you configure KeyView to include it. You can extract the cell value, the formula, or both. For example, if you choose to extract both the cell value and the formula, the output might look like this:

245 = SUM(B21:B26)

In this example, the calculated value from the cell is 245 and the formula from which the value is derived is SUM(B21:B26).

NOTE: Depending on the complexity of the formulas, enabling formula extraction might result in slightly slower performance.

To extract formulas

KeyView can extract Microsoft Excel formulas that contain the functions listed in the following table. If a function in a formula is not supported or is invalid, KeyView can extract only the calculated value.

Supported Microsoft Excel Functions

=ABS() =ACOS() =AND() =AREAS()
=ASIN() =ATAN2() =ATAN2() =AVERAGE()
=CELL() =CHAR() =CHOOSE() =CLEAN()
=CODE() =COLUMN() =COLUMNS() =CONCATENATE()
=COS() =COUNT() =COUNTA() =DATE()
=DATEVALUE() =DAVERAGE() =DAY() =DCOUNT()
=DDB() =DMAX() =DMIN() =DOLLAR()
=DSTDEV() =DSUM() =DVAR() =EXACT()
=EXP() =FACT() =FALSE() =FIND()
=FIXED() =FV() =GROWTH() =HLOOKUP()
=HOUR() =ISBLANK() =IF() =INDEX()
=INDIRECT() =INT() =IPMT() =IRR()
=ISERR() =ISERROR() =ISNA() =ISNUMBER()
=ISREF() =ISTEXT() =LEFT() =LEN()
=LINEST() =LN() =LOG() =LOG10()
=LOGEST() =LOOKUP() =LOWER() =MATCH()
=MAX() =MDETERM() =MID() =MIN()
=MINUTE() =MINVERSE() =MIRR() =MMULT()
=MOD() =MONTH() =N() =NA()
=NOT() =NOW() =NPER() =NPV()
=OFFSET() =OR() =PI() =PMT()
=PPMT() =PRODUCT() =PROPER() =PV()
=RATE() =REPLACE() =REPT() =RIGHT()
=ROUND() =ROUND() =ROW() =ROWS()
=SEARCH() =SECOND() =SIGN() =SIN()
=SLN() =SQRT() =STDEV() =SUBSTITUTE()
=SUM() =SYD() =T() =TAN()
=TEXT() =TIME() =TIMEVALUE() =TODAY()
=TRANSPOSE() =TREND() =TRIM() =TRUE()
=TYPE() =UPPER() =VALUE() =VAR()
=VLOOKUP() =WEEKDAY() =YEAR()