Thanks to some good advice here i finished by student achievement league table. However when i key in new numbers the totals and calculations do not change, I presume i have transfered the books incorrectly somehow and the formulas are locked in some way?. Can anyone here advise me what i have done wrong. I have attached my book for perusal and as you will see if you change the student scores, totals do not!
I just changed a few values, and the formulas updated just fine? Do you perhaps have calcs set to manual? Press F9 and see if it calcs then - if it does, you have manual on.
Your profile says 2003, but your workbook suggests 2007 or later, so based on that...
select Formula tab, click Calculation Options, male sure Automatic is checked
(also, please consider updating your version in your profile, members often tailor suggestions based on the version you say you have)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
yes it was in manual, now changed to automatic, thankyou for help much appreciated.
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks