Link to home
Start Free TrialLog in
Avatar of keith li
keith liFlag for Hong Kong

asked on

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 ?

User generated image
ASKER CERTIFIED SOLUTION
Avatar of helpfinder
helpfinder
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of keith li

ASKER

I found the fix from below, and thanks for everyone help !

User generated image
Avatar of Phillip Burton
Phillip Burton

I'm curious in that case how "the rest of the excel file can calculate automatically".