Is it possible to receive notification of a file update?

S

spavlica09

I have a project list in Excel that gets updated by multiple users. Is it
possible for Office or Windows to send me an alert or notification upon a
particular file being updated?
 
C

CLR

You would have to have a file open, and the Saved date of each file you were
concerned about in Column A.........then you could put something like this in
another cell and even Conditional Format if desired.......

=IF(A1<[FileToBeTested.xls]Sheet1!$A$1,"UPDATED","normal")

Of course the path and filename would have to reflect your actual's....

hth
Vaya con Dios,
Chuck, CABGx3
 
Top