ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Is it possible to receive notification of a file update? (https://www.excelbanter.com/excel-discussion-misc-queries/87366-possible-receive-notification-file-update.html)

spavlica09

Is it possible to receive notification of a file update?
 
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?

CLR

Is it possible to receive notification of a file update?
 
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



"spavlica09" wrote:

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?



All times are GMT +1. The time now is 05:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com