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)
 

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

Copy formula 6
VBA code copying formula not running correctly 3
Column of formulas with some cells containing data derived from thereformula's I would like to find 2
Copying Formulas 3
Excel Help to copy information from one row at a time to another sheet 1
Macro to copy formula based on range of other column 2
Reference Cell Altering Formulas 1
Excel Copy COUNTIF while retaining reference 7

Back
Top