Use code to stop "...contains one or more links that cannot be updated"

  • Thread starter Thread starter scooby
  • Start date Start date
S

scooby

I sequentially open then save & close about 30 files from a list in
master spreadsheet. I am receiving the link related messag
"...contains one or more links that cannot be updated" on open of eac
file. I need this message to be stopped from displaying by usin
code.

Thanks
 
Hi Scooby,
I sequentially open then save & close about 30 files from a list in a
master spreadsheet. I am receiving the link related message
"...contains one or more links that cannot be updated" on open of each
file. I need this message to be stopped from displaying by using
code.
Click to expand...

I presume you're opening them using code? If so, include
'updatelinks:=False' in the workbooks.open line, to prevent Excel trying
to update the links. Alternatively, if you want Excel to update whatever
links it can, you may be able to get away with setting
Application.DisplayAlerts to False before the call (and back to True
afterwards).

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk
 
Back
Top