Hi ...
I'm trying to figure out how to make a calculated value "stick" when my worksheet is closed.
For example, I have cell A1 constantly updated by an external feed. Cell A2 displays the maximum value that A1 has attained, using - if(A1<A2,A2,A1).
So far, so good ... until I close down excel.
How can I retain the maximum until the next time the workbook is opened?
G-fer
I'm trying to figure out how to make a calculated value "stick" when my worksheet is closed.
For example, I have cell A1 constantly updated by an external feed. Cell A2 displays the maximum value that A1 has attained, using - if(A1<A2,A2,A1).
So far, so good ... until I close down excel.
How can I retain the maximum until the next time the workbook is opened?
G-fer
