Array formulas convert to zero when e-mailing
One idea: check to see that the Add-Ins on the target computers match
the Add-Ins on your computer. In a sprdsht click ~Tools ~Add-Ins and
note that certain boxes (notably Analysis Tool-pak) are selected on
your machine. If the recipients' machines are not similarly checked
your formulas will not always work for them. Whether that would cause
the result to show as zero is a little troublesome and leads me to
think this may NOT be the problem, but it's worthwhile to check.
|