Description

This article is from the Spreadsheets FAQ, by Russell Schulz casfaq@locutus.ofB.ORG with numerous contributions by others.

10.17.1 Why do my User-Defined Functions return #VALUE! occasionally? (spreadsheets: Excel)

there is a problem with Excel 95 user-defined functions, in which they
are sometimes replaced by #VALUE when sheet operations take place. for
example, inserting or moving a sheet from one spreadsheet to another
will often result in all user-defined functions being replaced by a
#VALUE. forcing the sheet to recalculate will not remove the #VALUE.
re-entering the formula (and clicking the little green check box)
resolves the problem; also, global replacement of `=' with `=' (which
is no functional change) throughout the sheet will simulate this and
restore the correct values.

10.18.0 Matrix operations in Excel (Macro-Investment Analysis)

http://www.stanford.edu/~wfsharpe/mia/mat/mia_mat4.htm

 

Continue to:

• prev: 10.17 Why doesn't my spreadsheet recalculate? (spreadsheets: Excel)
• Index
• next: 10.18.1 How do I sum up or count column A when corresponding cells in column B match some condition? (spreadsheets: Excel)

Share and Enjoy

Tags

business, spreadsheets, Excel, Quattro, Lotus 1-2-3, free, open source, commercial, tab delimited, csv, formula, macro