Lofty Worm
asked on
Excell calculate issue
I have a user that has an intermittent issue.
the cells with formulas are not recalculating with the command button or refresh. they HAVE to double click each individual cell for it to update the value. How do I correct this?
the cells with formulas are not recalculating with the command button or refresh. they HAVE to double click each individual cell for it to update the value. How do I correct this?
Do I understand correctly that if the user presses [F9], the formulas will not recalculate?
you can Always do a repair of excel, or OFFICE
ASKER
I have not tried a repair, but I suspect it would not help. I will try anyway.
[F9] Did not work.
[F9] Did not work.
Make sure the cells holding the formula are correctly formatted (General or number, definitly not text)
I agree that a repair of Office is in order.
Any chance that "Calculate" or "Circular References" are visible in the status bar (bottom left)?
Any chance that "Calculate" or "Circular References" are visible in the status bar (bottom left)?
ASKER
Thank you all for your patience! I have gotten over to my user and done the testing;
- The repair is going to take a lot of time, so I would like to hold off for a little while longer unless I absolutely have to.
- I was wrong, and the F9 key DID work.
- The testing cell (result or tobe calculated) is set to Percentage, not text.
- The Bottom left status bar does show "calculate"
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This appears to have fixed the issue :)
Awesome, ty!
Awesome, ty!
ASKER
This appears to have fixed the issue :)
Awesome, ty!
Awesome, ty!
You're welcome.