Apr 4 2005, 04:18 AM
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.
Apr 4 2005, 09:40 AM
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)"?
Apr 4 2005, 11:32 PM
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.
Apr 5 2005, 01:42 AM
Must have something to do with Excel version Charley,
which Excel version are you using?
Apr 5 2005, 01:44 AM
I got the solution and posted it already. Any way am using Excel2000.
Apr 5 2005, 02:10 AM
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
Apr 5 2005, 02:14 AM
O.K. Am attaching the file.
Apr 5 2005, 02:18 AM
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.
Apr 5 2005, 02:25 AM
You are welcome.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here