Strange behavior

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!.
Click to expand...

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
 
Back
Top