Is there any way that I can update all of the links in one worksheet, while leaving the rest of the links in the other worksheets in my workbook alone? I have one worksheet with links that need to be updated regularly, and links in pivotcharts in several other worksheets that take FOREVER to update and don't need to be updated. All of the sheets need to stay in one workbook, so I can't split them into multiple excel files. As far as I can tell, .updatelinks only works with ActiveWorkbook, as in the following code (which is what I'm running right now):

Code:
ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSources
Any ideas?