PDA

View Full Version : Solved: Prevent "This workbook contains links" window from popping up



mferrisi
04-17-2008, 12:26 PM
I have a workbook called "Control" that opens and alters several other existing excel documents. When each of the documents opens, a popup window "This workbook cotains links to other data sources" opens, and I have to select either "update," don't update", or "help." Is there a way to prevent this popup from appearing? application.displayalerts = false doen't seem to work. Thank you!

lucas
04-17-2008, 12:32 PM
Try this:
Application.AskToUpdateLinks = True

lucas
04-17-2008, 12:33 PM
You'll probably want to set it to false.

I looked up update links in VBA help