| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically update a field only when data has changed
I have a worksheet that users will sometimes update data in, other times not.
I have a field that uses the =TODAY() function that I'd like to have updated ONLY if the data in the worksheet has changed and been saved. Is this possible? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
automatically update a field only when data has changed
Look he
http://www.mcgimpsey.com/excel/timestamp.html -- Kind regards, Niek Otten Microsoft MVP - Excel "bigdog2112" wrote in message ... I have a worksheet that users will sometimes update data in, other times not. I have a field that uses the =TODAY() function that I'd like to have updated ONLY if the data in the worksheet has changed and been saved. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a filename that will automatically update if changed. | Excel Worksheet Functions | |||
| graph won't update when data is changed | Charts and Charting in Excel | |||
| data in primay field changed however subsequent field does not upd | Excel Discussion (Misc queries) | |||
| How do you update a pivot chart when the data is changed? | Excel Discussion (Misc queries) | |||
| Charts don't update when data is changed, why not? | Charts and Charting in Excel | |||
Hybrid Mode
