• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 77
  • Last Modified:

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?
0
loftyworm
Asked:
loftyworm
1 Solution
 
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
 
loftywormAuthor Commented:
I have not tried a repair, but I suspect it would not help.  I will try anyway.

[F9] Did not work.
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
KoenChange and Transition ManagerCommented:
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
 
Glenn RayExcel 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
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now