IT News & Technology update

Provide comprehensive update related to Computer, technology, software, anti virus and another electric device

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.

  • 1. open Microsoft excel;
    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.

Related Posts by Categories

Widget by Hoctro | Jack Book
  1. 2 comments: Responses to “ Excel tips: Excel don't calculate automatically ”

  2. By Doldrums 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?

  3. 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

Search This Blog

Ads and Sponsored by:

Want to subscribe?

Subscribe in a reader.