You speak to average() formula errors. Just checking , do you realize that
the average formula reacts this way?

If an array or reference argument contains text, logical values, or empty
cells, those values are ignored; however, cells with the value zero are
included.
Arguments that are error values or text that cannot be translated into
numbers cause errors.


So when I do some dumps from our main frame a zero becomes an empty cell in
excel. If I need it to see a zero, it is an error in what I want to achieve.

OWC



"MaxA" wrote:

My spreadsheet has 6,000 rows by 14 colums; the 1st column is hyperlinks to
URLs. The file size is 7.5MB with the hyperlinks, but when I save the file
without the hyperlinks (copy column and paste special-values), the file is
only 0.5MB. Is this file size difference OK? The large file has some
unusual behavior (some math errors for averages) and I'm not sure if the file
is corrupt.