Hi All,

Am not an expert in Excel. I have a worksheet(not created by me) in which there is a formula say I2=SUM(E2:F2)
What happens is when i enter value in E2 then in F2 and Finally in G2, the formula in I2 changes as SUM(E2:G2) and the result also shown accordingly.

Any ideas

Charley

Hi, Charley
That is certainly strange behavior. I am not able to duplicate the behavior.
Some troubleshooting here
Does this happen on other workbooks, other places on the same worksheet? - Possibly a corrupted workbook.
What happens if you make the references absolute "=SUM($E$2:$F$2)"?

O.K I got the solution. To undo this,

1. On the Tools menu, click Options.
2. On the Edit tab, click to clear the Extend list formats and formulas check box. Click OK.

Regards,

Charley

Must have something to do with Excel version Charley,

which Excel version are you using?

M.

KingMartin,

I got the solution and posted it already. Any way am using Excel2000.

Regards,

Charley

I have seen your solution and I am using also Excel 2000.

But I couldn't reproduce the behavior, so I got curious.

Have a nice day

Martin

O.K. Am attaching the file.

I understand now. The empty cells are between the formula and your data and the formula automatically expands to comprise these cells as well once filled.

Thank you

M.

You are welcome.