Formula problem on network
 

Produced a workbook containing several worksheets and named ranges. A couple
of columns containing formulas work OK on stand alone computer. However, now
in use on a network of 20 or so computers the formulas in these columns will
sometimes show #NAME? error message, even though on another terminal they
work OK.

I'm mystified and any help or leads would be much appreciated

Thanks
Philip

Are they using functions from the Analysis Toolpak, and that is not
installed on some machines?

--
HTH

Bob Phillips

"Philip Reece-Heal" wrote in message
...
Produced a workbook containing several worksheets and named ranges. A
couple
of columns containing formulas work OK on stand alone computer. However,
now
in use on a network of 20 or so computers the formulas in these columns
will
sometimes show #NAME? error message, even though on another terminal they
work OK.

I'm mystified and any help or leads would be much appreciated

Thanks
Philip

Bob you are a genius; you just solved my problem at a stroke

Many thanks
Philip


"Bob Phillips" wrote in message
...
Are they using functions from the Analysis Toolpak, and that is not
installed on some machines?

--
HTH

Bob Phillips

"Philip Reece-Heal" wrote in message
...
Produced a workbook containing several worksheets and named ranges. A
couple
of columns containing formulas work OK on stand alone computer. However,
now
in use on a network of 20 or so computers the formulas in these columns
will
sometimes show #NAME? error message, even though on another terminal they
work OK.

I'm mystified and any help or leads would be much appreciated

Thanks
Philip