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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Result Does Not Change when a component does 3
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Excel Is this possible?? 3
How to keep formula and be able to input value in cell? 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Bizzare problem, need some HELP!! 3
Excel Drag autofill only part of formula 3
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2

Back
Top