autofill formulas return wrong answer

[john1968]

Hi,
I am trying to autofill a simple formula on my spreadsheet. The formula fills correctly( ie. the appropriate cells are used from each row and column), but the formula's result is the answer from the original cell down the whole column. I was using a spreadsheet e-mailed to me earlier that had macros running...could it be something to do with that?
Thanks
John

 

[VoG]

Hi. Tools > Options > Calculation tab, set calculation to Automatic.

 

[john1968]

Thanks very much!!