Why is formula not recognizing change in cell?

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

Guest

Several cells in my excell program are not responding to new data entry.
I've checked the formula and it remains the same as it has for years. The
cells above and below it having the same formula are working fine. I've
tried using manual calcuation, deleting and retyping the entry, moving the
information to a different place and then back, saving, closing and then
opening the file. I don't know what else to do. I also don't know how many
cells are affected. I've found 3-4 cells with the same problem by
painstakingly testing each cell in the area. I can no longer count on excell
recalculating newly entered numbers! Help!
 
One thing for which to check:

If some formulae update properly and others do not, the problem may be with
the data to whcih the cells refer. For example =SUM(A1:A100) will ignore
changes to A2 if A2 has been formatted as text.
 

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
cell shows formula...not formula result 5
SUM / COUNT formula 3
Copied formula shows original value until clicking in formula bar 1
Cell reference - displays formula rather then referenced cell 2
random cells with same formula will not display results 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Excel Formula for Eclipsing Circles 0

Back
Top