Excel tips: Excel don't calculate automatically
Written by IT News on 10:40 PM
In excel, it’s usually will automatically calculate when applying formulas in selected ranges of cells. If it not, then this simple tips will help you to solve this calculation problem.
2. Select option from the Tools menu;
3. Within the option dialog window, navigate to Calculation tab;
4. If the calculation set to manual now select Automatic;
5. Click OK,
Note: this tips tested in Microsoft office 2003
If this tips doesn't help this issue please let me know.
| Posted in »
2 comments: Responses to “ Excel tips: Excel don't calculate automatically ”
By Anonymous on December 19, 2007 at 1:15 PM
I've just had 3 people in our office where Auto-Calc somehow got turned off for them. I'm trying to figure out if there is some virus or malicious code causing this. Has anyone ever heard of anything like this?
By IT News on December 20, 2007 at 3:11 AM
Hello doldrums,
I'm not sure is that caused by a virus. If that persons has a macro documents, it's may effect some setting.
Find out under XLSTART folder, delete it if you found any files under this folder.
Which version do you currently using? If you use Microsoft Office 2003, please update to the latest service pack 3.0
Please let me know if you need my help.
IT news