slow response to change in cell

  • Thread starter Thread starter George
  • Start date Start date
G

George

Excel is set to manual recalculate. When I change text in a text cell,
response is immediate. When I change a precedent data cell, computer response
takes almost a minute (computer hd lite shows no activity), formula cells are
not changed. When I manually recalculate, the response is immediate. The
delay is terrible. Any ideas what I can do to correct this?
 
Did you try to set calculation to automatic and see whether you get any
problem?
 
Yes, my first suspicion was that there were excessive calculations. Now
after changing a data field the long delay occurs. When the delay ends,
dependent cells have not recalculated. Then when maually recalculating, the
response time was very short
 
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

Recalculate changes only 2
Trying to run excel vba code when cell value changes from empty to entered value. 1
VBA Created Worksheet Function Not Recalculating 5
whole workbook recalculates when I change a cell 3
Numbers change in cell even when formatted as text 4
Can you stop a formula from recalculating the second time 1
Display message while calculating forumlas 3
Static date formula 3

Back
Top