I have a spreadsheet that is linked to another spreadsheet using the following:
=IF(ISBLANK('http://uknetfs/BenefitPlanReview/[Benefit_Plan_Review_Log.csv]Benefit_Plan_Review_Log'!$N2),"",'http://uknetfs/BenefitPlanReview/[Benefit_Plan_Review_Log.csv]Benefit_Plan_Review_Log'!$N2)
Whenever I open the spreadsheet, excel asks whether I want to update links - if I press yes, a warning pops up to say that 'This workbook contains one or more links that cannot be updated'.
Ideally what I would like is for the spreadsheet to automatically update itself whenever it is opened without any manual intervention.
Hope you can help.
Kind regards
Bookmarks