View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bassman62 Bassman62 is offline
external usenet poster
 
Posts: 117
Default Last Save Time, Function not updating in cell

Using WinXP Pro and Excel 2007;
I have the following UDF in a code module of a workbook

Function LSDate()
LSDate = Application.Caller.Parent.Parent. _
BuiltinDocumentProperties("Last Save Time").Value
End Function

Cell A1 =LSDate()
The display date and time in the cell displays correctly when first the
formula is first entered but it does not update unless I re-enter the formula.
Automatic calculation is turned on. I've tried manually recalculating the
worksheet.
I've tried closing and reopening the worksheet.
Any suggestions as to how I can get the cell to update automatically?
Thank you.