Application.AskToUpdateLinks=False

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Matty S" wrote in message
...
How do I stop the Message "do you want to update links" coming up when I
open a workbook?