I'm a long time user of excel, very familiar with all its functions. Since
starting with a new computer, running Excel 2003, I run into the same problem
copying and pasting formulas. No matter what I do, paste special, selecting
formulas only, dragging the cell down, dragging multiple cells down, I get
the same frustrating result. The formula is always copied right, but the
result is always the exact same as the cell(s) that I copied from. If I
double click the copied cell, the formula executes. This is hugely time
consuming when talking about thousands of cells.

Anyone else run into this? Any solutions????

Tools-Options-Calculation tab-set to Automatic

HIH

On 3 Lis, 14:56, Kyle Richardson <Kyle
wrote:
I'm a long time user of excel, very familiar with all its functions. *Since
starting with a new computer, running Excel 2003, I run into the same problem
copying and pasting formulas. *No matter what I do, paste special, selecting
formulas only, dragging the cell down, dragging multiple cells down, I get
the same frustrating result. *The formula is always copied right, but the
result is always the exact same as the cell(s) that I copied from. *If I
double click the copied cell, the formula executes. *This is hugely time
consuming when talking about thousands of cells. *

Anyone else run into this? *Any solutions????

Then, I must ask.. If you go to tools Optins calculation, is it set to
Manual? If so, change to Automatic

"Kyle Richardson" wrote:

I'm a long time user of excel, very familiar with all its functions. Since
starting with a new computer, running Excel 2003, I run into the same problem
copying and pasting formulas. No matter what I do, paste special, selecting
formulas only, dragging the cell down, dragging multiple cells down, I get
the same frustrating result. The formula is always copied right, but the
result is always the exact same as the cell(s) that I copied from. If I
double click the copied cell, the formula executes. This is hugely time
consuming when talking about thousands of cells.

Anyone else run into this? Any solutions????