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


--
andyp161
------------------------------------------------------------------------
andyp161's Profile: http://www.excelforum.com/member.php...o&userid=11654
View this thread: http://www.excelforum.com/showthread...hreadid=400739