Are the formulas evaluating as zero or are the cell contents being replaced
with 0. Did you recently upgrade any of your office software?

If the array formula is evaluating as zero, that might be casued by it
reverting to a standard formula which could evaluate as zero. This can be
fixed by going to each formula and instead of hitting enter at the end, hit
CTRL-SHIFT-ENTER. As to why this would happen after being emailed, I don't
know.

" wrote:

At work, using Excel 2002 and Outlook 2002 . . . I have a
reasonable-size spreadsheet with several array formulas. Until
recently, they'd appear properly in recipients' systems after e-mailing
and opening. Now, these array formulas are replaced by the number zero
.. . . not quite as useful. This appears to be true whether the
recipient is in our e-mail domain or external.

As a band-aid, I know I can do the "ctrl-v - Edit|Paste Special|Values"
thing, but I'd like to see about getting back to the old way.

Is this likely to be a "feature" of Outlook, or some virus scan
reconfiguration, or something else? Any pointers are welcome.

Thanks -