Excel 97-remove link but keep data
search for .xls or [ or ] to see if you can find the formulas that contain links
to other workbooks.
Van wrote:
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!
--
Dave Peterson
|