On 4/30/08 11:23 AM, in article ee99fe0.1@[EMAIL PROTECTED]
"Audrey
Kiehtreiber" <audrey@[EMAIL PROTECTED]
> wrote:
> Hi Bob,
> Yes, I did use the Edit Links to see what the name of the external
workbooks
> were, and I tried a search but it didn't come up with anything. I had
read in
> a previous posting that other people have tried this method and it
didn't work
> for them either. They suggested using a tool .... but when I went to
look for
> it there was no indication if it worked in the 2008 version of Excel so
I am
> hesitant to try it until I hear back from the developer. Here is a quote
from
> a posting titled "Finding Pesky Links"
>
> "For hard to find links, download and install Bill Manville's FindLink
> add-in:
>
> <http://www.bmsltd.co.uk/MVP/Default.htm>"
>
> Do I need to search for the exact filename or can I just find using a
partial
> file name. The file names are long and weird... so I just used a single
word
> from them like RE****T to search. Someone else suggested using "[" but
that
> seemed to return nothing either. Suggestions?
>
> My feeling at this time is that there ARE no cells actually linked...
but
> before I break the links I'd like to verify this assumption. Does Excel
hold
> on to the link reference even when the cells have been deleted?
Bill Manville's tool will NOT work with Excel 2008 because it requires
VBA.
You should be able to search for a partial name, and using [ is a good
idea.
Just make sure that "[xxxxx" in the search is really the beginning of the
file name. did the file originate on Windows? Are there buttons or macros
attached to objects? These can also cause link references.
If the search show nothing, then break the links, save the file as a
backup
until you are sure there is no other damage.
--
Bob Greenblatt [MVP], Macintosh
bobgreenblattATmsnDOTcom
|
