Auto insert non updating static date in excel
This could be the case when you have a report and you want the printed copy to reflect the last update time.
To insert the current date, simply enter in the cell where you want it.
To turn it off, you need to go to Excel Options and uncheck the ‘Enable iterative calculation’ option.
To do this: Note that this formula is volatile and would recalculate every time there is a change in the workbook.
But the smart folks in Excel development team made sure that when a circular reference is found, it is not calculated and the non-ending loop disaster is averted.
However, there is a mechanism where we can force Excel to at least try for a given number of times before giving up.
You may also see a prompt as shown below: This happens as you are using the cell reference A3 in the calculation that is happening in A3.
Now, when circular reference error happens, there is a non-ending loop that starts and would have led to a stalled Excel program.
For example, you may want to track activities such as when was a particular expense incurred, what time did the sale invoice was created, when was the data entry done in a cell, when was the report last updated, etc. If you have to insert the date and timestamp in few cells in Excel, doing it manually could be faster and more efficient.