open workbook links

  1. O

    Vlookups not working unless external source workbook is open

    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...
  2. B

    Update links when opening workbook without opening source file

    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...

Some videos you may like

This Week's Hot Topics

Top