Dragging/copying formulas
 

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?

Dragging/copying formulas
 

Make sure calculation is set to automatic versus manual.

Tools/Options/Calculation - Automatic

"George Stauffer" wrote:

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?

Dragging/copying formulas
 

Thanks!

That worked instantly.

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






"JMB" wrote:

Make sure calculation is set to automatic versus manual.

Tools/Options/Calculation - Automatic

"George Stauffer" wrote:

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?

Dragging/copying formulas
 

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


"George Stauffer" wrote:

Thanks!

That worked instantly.

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






"JMB" wrote:

Make sure calculation is set to automatic versus manual.

Tools/Options/Calculation - Automatic

"George Stauffer" wrote:

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?

Dragging/copying formulas
 

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

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 ..
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--