Excel formula not updating automatically
How can I get it to react to changes automatically again?
I've enclosed the workbook so you can see what I mean when you start changing values in both sheets.
Data entry can be substituted to a certain degree by queries to external data sources. I recall a question that required knowledge of value changes.
In both sheet(1) and sheet(2) there are formula entered into cells but these do not autoupdate any more (they do if you hit Save however).
I feel that what you are trying to do with that worksheet is more than Excel was designed for.
There are software packages for traders that would do the job out of the box.
In sheet(2) the numbers get imported in via VBA but the formulas to add them all together are normal formulas in the cells themselves and do not react to the values that get pasted in via code.
In sheet(1) the data is manually entered - For example, if I try to change C4 from 4 in sheet(1) to 10 the formula in I4 should update but it doesn't.
Search for excel formula not updating automatically:
If Not Intersect(Target, Range("CM13")) Is Nothing Then If Is Empty(oldvalue) Then oldvalue = Target. Value Hello, The Worksheet_Change event will only fire when a cell is changed manually by the user.