Dragging/copying formulas

[Guest]

Sometimes I put a simple formula in a cell and then drag it to copy down the
column. Sometimes this works and the formula copies into neach cell. Other
times, the calculation from the first cell is copied, even though the proper
formula shows in each cell.

Does anyone know why?

 

[Guest]

Make sure calculation is set to automatic versus manual.

Tools/Options/Calculation - Automatic

 

[Guest]

Thanks!

That worked instantly.

I wonder why it gets changed to "Manual" sometimes without me changing it.

 

[Guest]

Could be a macro in a workbook that you opened setting calc to manual. This
is a popular and effective technique to make macros run faster. But, if the
macro doesn't change calc back to automatic......

 

[Max]

I wonder why it gets changed to "Manual"
Another behaviour thought ... Per session (start Excel - exit Excel), think
Excel will assume the calc mode of the first book which is opened in that
session. So if the calc mode of that first book happened to be set to
manual, any subsequent book(s) opened within the same session (i.e. w/o
exiting Excel) will take on manual calc mode, irrespective of their saved
calc modes. It's good to be aware of this ..