Updating problem 1

[UnsolvedCoding]

I am having a problem with the workbook wanting to use a popup window each time a link is updated instead of it auto updating using this line of code:

ThisWorkbook.UpdateLink Name:=ThisWorkbook.LinkSources

Anyone know why and how to update the formulas without the annoying popups making people think the workbook is broken?

It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.

 

[combo]

You can disable updating linls manually or by code ([tt]ThisWorkbook.UpdateLinks = xlUpdateLinksNever[/tt]) and next update them only by your code above.

combo

 

[UnsolvedCoding]

Thanks Combo, it looks like this solved the problem.

It has taken me a while to make sense of what I hear at work involving computers. There is much talk of bugs and questions about Raid.
Therefore I have come to the logical conclusion that the only way to have a properly functioning computer is to regularly spray it with Raid bug killer.