Hi all please help!

I do regular autofill of 20 columns to like 500 rows. Then the code stuck and pressing CTRL+BREAK the announcement that Excel cannot update links pops up. If after that update links from Data-links-... updating goes just perfect.

Selection.AutoFill Destination:=Range("A4:X" & Workbooks("Bonds.xlsm").Sheets(1).Range("B2") + 2), Type:=xlFillDefault
What is the solution or alternative?

Thanks is avance!!