Drop and drag is copying values instead of formulas
 

Why would this happen?

Drop and drag is copying values instead of formulas
 

Have you filtered your data?

joel1972 wrote:

Why would this happen?

--

Dave Peterson

Drop and drag is copying values instead of formulas
 

No. I highlight a number of cells, and then attempt to drag the formulas
down. The odd part is, the formulas (v-lookups) will drag down correctly,
but the values of the highlighted cells are what appears.

"Dave Peterson" wrote:

Have you filtered your data?

joel1972 wrote:

Why would this happen?

--

Dave Peterson

Drop and drag is copying values instead of formulas
 

If you have, show all of it before dragging.

Dave Peterson wrote:

Have you filtered your data?

joel1972 wrote:

Why would this happen?

--

Dave Peterson

--

Dave Peterson

Drop and drag is copying values instead of formulas
 

Press F9 to recalculate your worksheet.
--
Brevity is the soul of wit.


"joel1972" wrote:

No. I highlight a number of cells, and then attempt to drag the formulas
down. The odd part is, the formulas (v-lookups) will drag down correctly,
but the values of the highlighted cells are what appears.

"Dave Peterson" wrote:

Have you filtered your data?

joel1972 wrote:

Why would this happen?

--

Dave Peterson

Drop and drag is copying values instead of formulas
 

Not clear what is happening from your description, but maybe you are in Manual
calculation mode?

ToolsOptionsCalculation. Check Automatic.


Gord Dibben MS Excel MVP


On Fri, 15 Sep 2006 10:58:02 -0700, joel1972
wrote:

No. I highlight a number of cells, and then attempt to drag the formulas
down. The odd part is, the formulas (v-lookups) will drag down correctly,
but the values of the highlighted cells are what appears.

"Dave Peterson" wrote:

Have you filtered your data?

joel1972 wrote:

Why would this happen?

--

Dave Peterson


Gord Dibben MS Excel MVP