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)


"Chip" <Chip@discussions.microsoft.com> wrote in message
news:63823C67-2F89-4569-BE88-733CD58FB6EB@microsoft.com...
> 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