I'm might be hoping for too much but....

[Excelnewie]

....thought I would ask anyway.

i have 5 different workbooks (data added by team captains) that feed into one table combined by a power query (viewed by team manager).

Captains add data to their table and the manager can see this when he refreshes his query. All is working well.

Now, is there a way to notify the manager that a new record has been added? Ideally he would open his worksheet and there would be something there to say for example "3 new records have been added". i don't want to use macros.

I hope i am I am not asking for too much.... Any help or suggestions are appreciated

Thanks

 

[alansidman]

Why not have the Query Refresh Automatically whenever the file is opened. To do this, click on the refresh drop down. Select "Connection Properties". Check box "refresh data on opening file" should be checked.

 

[Excelnewie]

H. Thanks for the reply. I wanted there to be a notification that there is a new entry. They don't occur daily so it would save him time to know if there was something new rather than looking through the whole sheet