• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Strange occurance in excel ... need advice

John()

Member
Ok was doing a macro for someone who posted in this forum .... when the following occurance effects how it works
and was wondering dose it happen with other peoples excel or just mine
have a simple formula in column C ... =B1+A1
which i then drag down for say 10 rows .... now i fill row A with numbers down to row 10 and they as expected appear in Column C ...... Problem is when i add a value to A11 it also appears in Colum C11 even though i dindnt add the fromula to that cell (it automatically adds the formula to the cell)
and if i continue adding values in Column A they keep appearing in Column C

so did a little investigating and found if i only dragged the formula down three rows in Column C ... excel behaved the way i expected eg add values to A1 A2 and A3 they appear in Column C ... add a value in A4 no value appears in C4
But if i drag the formula down to C4 then it will keep on adding the values to column C when i add them in A5 down (it also adds the formula in column C)

Closed down all work books and restarted excel and still it happens
Using 2007 version
Any thoughts ?????
 
Hello,
Excel automatically copies a formula if the previous five rows contain the same formula. You can turn this off in the Excel options > Advanced > untick "Extend data range formats and formulas"

cheers, teylyn
 
Last edited:
Check the Options-Advanced-Editing Options and see what's checked therein - I don't have 2007, but it may well be that Extend data range formats and formulas is checked and/or Enable AutoComplete for cell values .... that's where I think this behavior emanates ....
 
Thanks guys that sorted it ...... did not Know about that .... might be able to do a workaround for macro now
 
Back
Top