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:
  1. Dim wkApp As Excel.Application

  2. Set wkApp = CreateObject("Excel.Application")

  3. wkApp.DisplayAlerts = False

  4. ActivePresentation.UpdateLinks

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

Any ideas?
thanks
Tyler