10.17.1 Why do my User-Defined Functions return #VALUE! occasionally? (spreadsheets: Excel)
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:
My Books
