AutoFill w/formulas

I have three columns of data B1, C1, D1 which I concatenate into a fourth
column E1. Then I need to use the autofill function in the fourth column do
autofill the formula on all rows below the initial cells.

What is happening is that on each subsequent row, it is actually copying the
data in cell E1 down through each cell. However, when I click on one of the
cells and look in the formula bar, the formula is correct but the resulting
data is not.

Am I doing something here?

Maybe you have calculation set to manual under tools>options>calculation,
set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please)


"JamesElting" <JamesElting@discussions.microsoft.com> wrote in message
news:67C44E90-610A-43E7-8172-89454CB22E47@microsoft.com...
>I have three columns of data B1, C1, D1 which I concatenate into a fourth
> column E1. Then I need to use the autofill function in the fourth column
> do
> autofill the formula on all rows below the initial cells.
>
> What is happening is that on each subsequent row, it is actually copying
> the
> data in cell E1 down through each cell. However, when I click on one of
> the
> cells and look in the formula bar, the formula is correct but the
> resulting
> data is not.
>
> Am I doing something here?

Maybe you have calculation set to manual under tools>options>calculation,
set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please)


"JamesElting" <JamesElting@discussions.microsoft.com> wrote in message
news:67C44E90-610A-43E7-8172-89454CB22E47@microsoft.com...
>I have three columns of data B1, C1, D1 which I concatenate into a fourth
> column E1. Then I need to use the autofill function in the fourth column
> do
> autofill the formula on all rows below the initial cells.
>
> What is happening is that on each subsequent row, it is actually copying
> the
> data in cell E1 down through each cell. However, when I click on one of
> the
> cells and look in the formula bar, the formula is correct but the
> resulting
> data is not.
>
> Am I doing something here?

Maybe you have calculation set to manual under tools>options>calculation,
set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please)


"JamesElting" <JamesElting@discussions.microsoft.com> wrote in message
news:67C44E90-610A-43E7-8172-89454CB22E47@microsoft.com...
>I have three columns of data B1, C1, D1 which I concatenate into a fourth
> column E1. Then I need to use the autofill function in the fourth column
> do
> autofill the formula on all rows below the initial cells.
>
> What is happening is that on each subsequent row, it is actually copying
> the
> data in cell E1 down through each cell. However, when I click on one of
> the
> cells and look in the formula bar, the formula is correct but the
> resulting
> data is not.
>
> Am I doing something here?