Hello,

I have a client who uses excel and has a problem with creating auto
formulas.

She creates a formula such as =ROUND(D5*$G$5,2) and it works fine. She then
grabs the lower corner and drags it down to the rest of the columns and the
resutl is the same answer as the original cell. When you look at the
formula for each cell they are correct (the correct formula indicating the
correct row). If you go to the formula bar and place the cursor behind the
formula and press enter the correct result is then displayed for that cell.
You have to do that for every cell for the answer to be correct. The
version is Excel 2002 SP3. I ran a detect and repair and even reset the
default settings with no change.

JCLSB

Tools>Options>Calculation tab, check Automatic

--
Kind regards,

Niek Otten

"JCLSB" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hello,
>
> I have a client who uses excel and has a problem with creating auto
> formulas.
>
> She creates a formula such as =ROUND(D5*$G$5,2) and it works fine. She
> then
> grabs the lower corner and drags it down to the rest of the columns and
> the
> resutl is the same answer as the original cell. When you look at the
> formula for each cell they are correct (the correct formula indicating the
> correct row). If you go to the formula bar and place the cursor behind
> the
> formula and press enter the correct result is then displayed for that
> cell.
> You have to do that for every cell for the answer to be correct. The
> version is Excel 2002 SP3. I ran a detect and repair and even reset the
> default settings with no change.
>
> JCLSB
>
>
>

Niek,
Corrected the problem

Thank You


"Niek Otten" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Tools>Options>Calculation tab, check Automatic
>
> --
> Kind regards,
>
> Niek Otten
>
> "JCLSB" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Hello,
>>
>> I have a client who uses excel and has a problem with creating auto
>> formulas.
>>
>> She creates a formula such as =ROUND(D5*$G$5,2) and it works fine. She
>> then
>> grabs the lower corner and drags it down to the rest of the columns and
>> the
>> resutl is the same answer as the original cell. When you look at the
>> formula for each cell they are correct (the correct formula indicating
>> the
>> correct row). If you go to the formula bar and place the cursor behind
>> the
>> formula and press enter the correct result is then displayed for that
>> cell.
>> You have to do that for every cell for the answer to be correct. The
>> version is Excel 2002 SP3. I ran a detect and repair and even reset the
>> default settings with no change.
>>
>> JCLSB
>>
>>
>>
>
>