On 5/2/08 10:44 AM, in article ee99fe0.3@[EMAIL PROTECTED]
"Audrey
Kiehtreiber" <audrey@[EMAIL PROTECTED]
> wrote:
> Hi Bob,
>
> I did the search again using the suggested parameters, and still didn't
find
> anything. I searched for "[Filename_First_Word".
>
> I began a manual search by switching between worksheets, and at one
point an
> alert notified my that the sheet I was on had a link. I then clicked on
each
> object to manually see what the cell references were, and finally
clicked on a
> Chart and found that it was what had the external reference.
>
> Again, the previous search didn't bring it up, even though the chart was
using
> external references to files I had included in my search attempts.
>
> There are 68 worksheets in this workbook, is there NO way to find out
which
> cells/Charts are using external links? I find it surprising and
disappointing
> that there is no mechanism for dealing with this problem.
>
> I appreciate your help on this. Any suggestions?
Without macros, I'm afraid that it will be difficult. The series formulas
in
a chart is not "FINDable". Why do you need to find the links? To change
them, you can use the change Link. If you want to remove them, use Break
Link.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom


|