Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formulae - delay updating when the sheet is refreshed
Hi I use these formulae to insert the date and time in separate cells on a worksheet : A14 =TODAY() B14 =NOW()-TODAY() They update automatically when I open the sheet. It would be better however if they didn't do this until I use the Refresh All function. Is it possible to stop these functions updating until I need them to do so? I know I can switch global options off in the Options section of the program , but I'm loathe to do this for the sake of this one sheet. Grateful for any advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating chart from refreshed pivot table data | Charts and Charting in Excel | |||
Formulae not updating | Excel Discussion (Misc queries) | |||
Time Delay for Macros | Excel Discussion (Misc queries) | |||
Getting the last time a web query was refreshed. | Excel Worksheet Functions | |||
Long Time Delay To Paste From UserForm To Sheet | Excel Worksheet Functions |