I have a shared workbook that is working but when an auto-update occurs (set at every 15 mins) any new data from other users is appended to the foot of a table. I would like it to use my sort macro but am unaware of an event that would trigger it. I have tried the Workbook beforesave macro but it does not seems to get triggered. I could use the 'change' event but I am using it for a number of actions and so need something to indicate the occurrence of an auto-update. Any ideas of how I could automate the sort as a consequence of shared workbook auto update?