Tuesday, December 11, 2007

Excel tips: Excel don't calculate automatically

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.

at

2 comments:

  1. AnonymousDecember 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?

    ReplyDelete
  2. IT NewsDecember 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

    ReplyDelete