Excel 2013 forumal problem

Hi All


             I have a problem in excel 2013, the formual can not update automatically after i modified the number in the field, i do need to click on the total sum field to press enter manually in order to have the update number, i have tried to copy this excel to another computer, it has no problem at all, and only this excel file got problem on the computer, the rest of the excel file can calculate automatically, any idea what goes wrong ?

excel2013
piaakitAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

helpfinderIT ConsultantCommented:
On the Formulas ribbon, look to the far right and click Calculation Options. On the dropdown list, verify that Automatic is selected.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
Can you post your spreadsheet please.
0
QlemoBatchelor, Developer and EE Topic AdvisorCommented:
Try to replicate the issue with a new workbook by copying the related data and formula.
Can you post the workbook?
0
Exploring ASP.NET Core: Fundamentals

Learn to build web apps and services, IoT apps, and mobile backends by covering the fundamentals of ASP.NET Core and  exploring the core foundations for app libraries.

Danny ChildIT ManagerCommented:
I've seen a glitch in some sheets where formulas would not recalculate.  The slow fix was to press F2 on the offending cell to start editing it, then press Enter.  The fast fix was to do a Find/Replace, looking for the = character, and replacing it with the exact same = character.
This seemed to force Excel to re-evaluate every cell, and it was then fine from that point onwards.

I suspect some corruption within the sheet itself may have been the root cause - may need to copy all content to a new workbook.
0
piaakitAuthor Commented:
I found the fix from below, and thanks for everyone help !

excel
0
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I'm curious in that case how "the rest of the excel file can calculate automatically".
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.