keep having to press enter
I have an invoice which was fully fuctional but now I keep having to press on the box and then enter for the formula to correct itself everytime I alter something, is there a fix for this?
If I enter 10:00 in F31 H31 should automatically tally up but its not, the same as all the other boxes I have to presse nter on each box that contains a formula
Last edited by louise2613; 12-18-2012 at 09:18 AM. Reason: attachment added
hi lousie2613, is your auto-calculation turned on? go to the tab Formulas -> Calculation Options -> Automatic
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
I reckon you have calculation set to manual. select the formulas tab then click calculation options on the right and select automatic
Josie
if at first you don't succeed try doing it the way your wife told you to
Excellent, thats done the job - thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks