Answered

How to re-enable automatic calculation in excel?

0

I have a spreadsheet with several calculations and DDE links. After I installed NumXL the spreadsheet stopped calculating automatically: I have to press F9 every time I want calculations to be updated. But as I work with DDE links, it´s mandatory to have everything being updated automatically in real-time. How do I fix this?

Comments

1 comment
  • NumXL should have restored the automatic calculation, but it appears some operation must have terminated prematurely.

    Anyway, to re-enable the automatic calculation:

    1. In Excel 2007 and later: Go to the FORMULAS tab, locate the Calculation Options icon (rhs), and select automatic calculation.

    Excel2010-autocalc.png

    2. In Excel 2003 or earlier, Go to "Tools" in the menu, and select "Options". Once the options dialog is up, select the "Calculations" tab

    Excel2003-options-menu.png

     

    Excel2003-options-calculation-dialog.png

    0
    Comment actions Permalink

Please sign in to leave a comment.

Didn't find what you were looking for?

New post