Strange behavior

Everything was working okay until yesterday.

When I change input data in one cell (400,000 to 300,000) for example; the
data in the cell with a formula does not change but shows #name!.

This happens on two different spread sheets I have created. One, affects
the cell with the formula as stated above and the other affects another cell
with a formula.

It appears the #name! error comes up based on the number of rows apart the
input cell and the formula cell are.

Sure could use some help on this one.

Hi Greg,

> Everything was working okay until yesterday.
>
> When I change input data in one cell (400,000 to 300,000) for example; the
> data in the cell with a formula does not change but shows #name!.

Could you show us the formula in the cell that now shows #Name! please?

I suspect you (or something else) have uninstalled the Analisys Toolpak Addin
(tools, add-ins).

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com