AutoComplete not functioning correctly
 

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

AutoComplete not functioning correctly
 

ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten

"JCLSB" wrote in message
...
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

AutoComplete not functioning correctly
 

Niek,
Corrected the problem

Thank You


"Niek Otten" wrote in message
...
ToolsOptionsCalculation tab, check Automatic

--
Kind regards,

Niek Otten

"JCLSB" wrote in message
...
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