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?

Glenn Ray

Do I understand correctly that if the user presses [F9], the formulas will not recalculate?

nobus

you can Always do a repair of excel, or OFFICE

Lofty Worm

ASKER

I have not tried a repair, but I suspect it would not help. I will try anyway.

[F9] Did not work.

Koen

Make sure the cells holding the formula are correctly formatted (General or number, definitly not text)

Glenn Ray

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)?

Lofty Worm

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

Glenn Ray

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Lofty Worm

ASKER

This appears to have fixed the issue :)
Awesome, ty!

Lofty Worm

ASKER

This appears to have fixed the issue :)
Awesome, ty!

Glenn Ray

You're welcome.