If you are asking to find which cell in your workbook contains a paste link formula, start by right-clicking any sheet tab, and select Select All Sheets. Then hit Ctrl+F and in teh Find what field, enter *[* and see what cell(s) are found that containlinks to other workbooks.
In teh Find what box type ! and that will also help.
If the work being done is always on your computer, you can avoid VBA by clicking on Tools > Options > Edit > select Ask to update automatic links.
Or if you want to disable it only before your macro opens your workbook, and enable it immediately thereafter, put this in your macro:
Application.AskToUpdateLinks = False
Workbook.Open Filename:="G\Your\File\Path\Filename.xls"
Application.AskToUpdateLinks = True
Or
Workbooks.Open Filename:="C:\Your\File\Path\Filename.XLS", UpdateLinks:=0
Note, arguments for UpdateLinks:
0 Does not update any references
1 Updates external references only, not remote references
2 Updates remote references only, not external references
3 Updates both remote and external references
or place this in your workbook module
Private Sub Workbook_Open()
ThisWorkbook.UpdateLink _ Name:=ThisWorkbook.LinkSources
End Sub
To easily access your workbook module, find the little Excel workbook icon near the upper left corner of your workbook window, usually just to the left of the File menu option. Right click on that icon, left click on View Code, and paste the following procedure into the large white area that is the workbook module. Press Alt+Q to return to the worksheet.
In 2007 or 2010, Alt+F11 > Ctrl+R and expand the Objects folder for your workbook project.
And someone else will no doubt post other ways; these are just a few options.
)
