PowerPoint - Updating Linked Objects without Alerts

I have a set of slides (PP 2000) with multiple linked objects (to Excel 2000). Many of the excel workbooks have macros and additional external links. When I update the links in Powerpoint I get multiple instances of alert messages asking if I want to enable the macros in the excel files and update the links, again in the excel files.

I have tried to suppress the alerts using the below code

VB Code:

Dim wkApp As Excel.Application
Set wkApp = CreateObject("Excel.Application")
wkApp.DisplayAlerts = False
ActivePresentation.UpdateLinks

This gets rid of the prompt to enable macros but not the prompt to update the excel links.

Any ideas?
thanks
Tyler