How do I stop my formulas from updating?
How do I stop my formula =IF(D81,NOW(),) from updating every time I open
the document? I am using this formula for a form that is filled out electronically; I am using this formula with a locked cell so that the date and time cant be modified. If I save the document and then reopen it refreshes every time I do. How can I stop this from happening? |
How do I stop my formulas from updating?
I would use a macro instead of an equation. The macro could continuously
monitor D8 and, when it exceeds 1, set the date/time in a static fashion. The form of the macro depend on whether D8 is calculated or manually entered. -- Gary''s Student - gsnu200851 "Shaun" wrote: How do I stop my formula =IF(D81,NOW(),) from updating every time I open the document? I am using this formula for a form that is filled out electronically; I am using this formula with a locked cell so that the date and time cant be modified. If I save the document and then reopen it refreshes every time I do. How can I stop this from happening? |
How do I stop my formulas from updating?
How do I stop my formula =IF(D81,NOW(),"") from updating every
time I open the document? I am using this formula for a form that is filled out electronically; I am using this formula with a locked cell so that the date and time can't be modified. If I save the document and then reopen it refreshes every time I do. How can I stop this from happening? One way is to use a circular reference. To allow circular references, use Tools Options Calculation and check the "Iterations" checkbox. Then, if your formula is for A1, try something like this as the formula: =IF(D81,IF(N(A1)0,A1,NOW()),"") Adjust to suit. Caution: allowing circular references can be a risk. Later, if somebody adds a circular reference in the workbook by mistake, Excel won't flag it as an error. |
All times are GMT +1. The time now is 07:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com