View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Van
 
Posts: n/a
Default Excel 97-remove link but keep data

Hi guys,

I have a pre-existing excel 97 s/s which has links to other s/s's. I would
like to keep the data only (like paste-special, values) and remove the linked
reference from showing in the current s/s. Any ideas how to do this instead
of me changing each linked reference?
Thanks in advance!