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?
LVL 11
loftywormAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
Change the calculation option to Automatic:

Menu:  Formulas tab, Calculation Options, Automatic
EE-CalcOptions.png
Save the file after changing the setting.

-Glenn
0
 
Glenn RayExcel VBA DeveloperCommented:
Do I understand correctly that if the user presses [F9], the formulas will not recalculate?
0
 
nobusCommented:
you can Always do a repair of excel, or OFFICE
0
Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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

[F9] Did not work.
0
 
KoenCommented:
Make sure the cells holding the formula are correctly formatted (General or number, definitly not text)
0
 
Glenn RayExcel VBA DeveloperCommented:
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)?
0
 
loftywormAuthor Commented:
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"
0
 
loftywormAuthor Commented:
This appears to have fixed the issue :)
Awesome, ty!
0
 
loftywormAuthor Commented:
This appears to have fixed the issue :)
Awesome, ty!
0
 
Glenn RayExcel VBA DeveloperCommented:
You're welcome.
0
All Courses

From novice to tech pro — start learning today.