Sub Update_all_Links() ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources End Sub Source: Microsoft.com « Creating a Chart with Stacked and Unstacked Columns Hide 0 values in your excel chart (stop it from dropping to 0) »