General discussion


why formula does not work in excel?

By webmaster ·
In our LAN, one colleague asks for my help:
He has an excel file, with some formula defined. But now the result doesn?t change after he changes the source value (in same sheet).
I then tried, first open a new blank file, formula works properly. But after opening that file, immediately formula stop working for changes, even opening a new file.
I suspect those files contain virus, but the Anti-Virus software cannot find any virus from that computer.
Furthermore, I tried to open that file in another computer, and the formula doesn't work either.
It seems the formula cannot refresh data.
What might be the reason?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by OTL In reply to why formula does not work ...

Could be cell has been protected/locked. Highlight the cell, left click, format cell, under the protection tab see if it is locked. If so would have to go to tools, protection and whatever is locked will say unprotect.

May also be sheet is set to manual/automatic except tables for recalculation to check goto tools -> options -> calculation and change it to automatic.

Collapse -

by webmaster In reply to

Poster rated this answer.

Collapse -

by webmaster In reply to why formula does not work ...

This question was closed by the author

Related Discussions

Related Forums