Help please! I have a workbook that is vlooking up to another workbook. The issue is that when I open up the WB that has the vlookups, it gives me the update links dialog box (which is fine). When I click update, I then get an error box that it cannot update the links and #refs everything...
I am using the code below to open a workbook...
Sub OpenGPK()
Workbooks.Open Filename:="\\lon0306\dfs\data\dta\sim_spf\charities team\applications\Gourmet Performance Kitchen.xls"
End Sub
However whilst opening this workbook I would also like to update links to from workbook without opening...