On Tue, 27 May 2008 10:32:37 -0400 Anthony Chilco <[EMAIL PROTECTED]> wrote:
>
>
> Jerry Feldman wrote:
> > On Tue, 27 May 2008 08:48:58 -0400
> > Jerry Feldman <[EMAIL PROTECTED]> wrote:
> >
> >> I have a spreadsheet that has about 10 sheets. When starting up it
> >> reports that it has links to other files. This certainly was true
> >> months ago when the maintainer first started the spreadsheet, but we
> >> thought we had purged all of those. She maintains it on her PC, then
> >> pushes it up to a Samba share. Is there a way that I can search either
> >> the entire document or each sheet to find the link. AFAIK, there are no
> >> errors on any of the sheets.
> >
> > I was premature here. Edit/Links... will identify the links, but do not
> > point to the cells that contain them, but you do have the capability to
> > break or update the links.
> >
> >
> Hi Jerry,
> If you want to identify the cells containing links, try searching for
>
> =DDE("soffice";
No occurrence of DDE. It is interesting that when I run Excel it does
not detect any links. Only Open Office. I'm wondering if there is
artifact left over from Excel. In any case, it was just a minor PIA
when opening up the .xls. I normally rewrite it as .ods since I like to
change column widths and stuff, so I can compare figures with the
product I'm working on.
--
--
Jerry Feldman <[EMAIL PROTECTED]>
Boston Linux and Unix
PGP key id: 537C5846
PGP Key fingerprint: 3D1B 8377 A3C0 A5F2 ECBB CA3B 4607 4319 537C 5846
signature.asc
Description: PGP signature
