Formula won't copy down the column

  • Thread starter Thread starter Chip
  • Start date Start date
C

Chip

I am trying to copy a formula down a column. I have done it for years and
worked fine. This time, the first result appears in each cell, but if you
look at the formula in copied cells, they show the correct formula has
changed as I dragged it down the column.

So, the formula changes as I drag, but the answer stays the same as the
original cell.

The data was sent to me by someone else and I am working with it. I have
even copied just the delivered data to a new spreadsheet and the same result.

Please help
 
It sounds like Calculation in Excel is set to Manual.

Try this:
From the Excel Main Menu:
<tools><options><calculation>
....Check: Automatic

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)
 
Back
Top