Generates a list of all cells that have dependent cells. Changing the value of any cell on this list would change the value of other cells in the spreadsheet.
For files in this location, both data connections defined in trusted data connection libraries and connections embedded in ...
fractional_dollar,fraction!Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal ...
function_num,options,array,k!function_num,options,ref1,.!Returns an aggregate in a list or database!is the number 1 to 19 ...
function_num,ref1,.!Returns a subtotal in a list or database!is the number 1 to 11 that specifies the summary function for ...
Generates a list of all cells that have dependent cells. Changing the value of any cell on this list would change the value ...
Generates a list of cells containing any formula with a numeric constant as part of its formula. For example, =SUM(A3:B7)*25.2 ...
Generates a list of cells containing any formula with a textual constant as part of its formula. For example, ="Hello world" ...
Generates a list of cells containing array formulas. On the spreadsheet, Excel will show arrays formulas with surrounding ...
Generates a list of cells containing duplicate formulas. Duplicate formulas are formulas that are duplicated one or more ...