pasting formulas

  • Thread starter Kyle Richardson
  • Start date
K

Kyle Richardson

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????
 
S

Sean Timmons

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why paste between workshhets yields values only 6
Excel 2007 - A Conditional Formatting ?'s 1
Odd Formula copying Behavior 3
unable to copy cell reference 6
Why did auto calculate suddenly change to manual calcu... 4
Auto Fill formula when inserting a new line 4
help: paste special with an operation (add, multiply,...) convertseverything to values, pasted formu 1
Formulas are becoming text strings 2

Top