Have you tried the After Refresh event?:

http://support.microsoft.com/default...87&Product=xlw

--
Jim Rech
Excel MVP
"tommyboy " wrote in message
...
|I am using the get external data in excel so a cell will update
| automatically into a new cell every time data is refreshed,
|
| but as this is imported and not entered by user edit the
| worksheet_change doesnt work,
|
|
| ---
| Message posted from http://www.ExcelForum.com/
|