Excel re-calculation for almost entire sheet when changing content of empty cell

[björn_sweden]

Hi peepz,

I am really in need of desperate help, I have been trying to find the answer for my question the last 4 hours and haven't got any closer to a solution.
The problem has to do with an unexpected change to a small in size "less than 3 mb" but very complex workbook which normally calculates fast when doing small changes.

Since today when I just write "a" and press enter in an empty cell the workbook starts to re-calculate itself which takes about 10 seconds. I don't understand why this is happening and how to change it. I checked previous version of the workbook which work fine, however there has been approx 24 hours develop in the new version which kind of means that I need to fix it since doing things over again isn't an option.

Even when I open a new empty workbook and make a small change it takes 10 seconds to re-calculate, and this new workbook is not linked to my other workbook.

Please help.

 

[Derek Brown]

Hello and welcome to The Board.
Do you have any other workbooks open? Excel is likely to recalculate them all when one recalculates.
Perhaps the following will help:
How the Excel Smart Recalculation Engine works - Decision Models
Excel Recalculation

 

[britsgal]

You could also just change your calculation to Manual. If you have Excel 2010, under File, Options, Formulas, click the "manual" radial button. You can then manipulate your spreadsheet as much as you want. When you are finished manipulating it, hit F9 to calculate. If you don't like this, you can always follow the same steps as outlined changing the radial button to "automatic".