Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a worksheet with a UDF that displays the last saved date. There are
other cells which have dependancies on this date. When saving and reopening the document the date remains unchanged. I have tried F9, Shift + F9, CTRL + ALT + F9, CTRL + SHIFT + ALT + F9 and also changing the settings in OPTIONS CALCULATION from automatic to manual back to automatic. Recalculate before save is checked. When I close the workbook and reopen the date remains the same. If I retype the formula in another cell then the date displays correctly. Can anyone help? Much appreciated! Joe M. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Recalculation? | Excel Discussion (Misc queries) | |||
Recalculation | Excel Discussion (Misc queries) | |||
recalculation | Excel Discussion (Misc queries) | |||
Recalculation | Excel Worksheet Functions | |||
Recalculation | Excel Discussion (Misc queries) |