Is it possible to receive notification of a file update?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top