close

When I open a workspace, I receive a dialogue box with a link listed in the
dialogue box title bar. I am not able to find the link in any of the active
workbooks within the workspace. Does anyone know how to locate the listed
links or eleminate the dialogue box?

Maybe one of these tricks apply to your situation...?

1) Have you tried selecting all of the sheets and CTRL F a portion of text
from the name of the linked workbook? If your link is to bookxyz.xls, you
can just look for all occurances of quot;xyzquot;.
or
2) Do you have any named ranges? Try going to insert gt; name gt; define. If
your workbook has named ranges that came from another book you can get a
link notice upon opening.

Best Regards,
Mike

quot;LTB @ Miami, OKquot; lt;LTB @ Miami, gt; wrote in
message ...
gt; When I open a workspace, I receive a dialogue box with a link listed in
gt; the
gt; dialogue box title bar. I am not able to find the link in any of the
gt; active
gt; workbooks within the workspace. Does anyone know how to locate the listed
gt; links or eleminate the dialogue box?
Thanks Mike,

I have completed #1 but was not aware of option #1 - will try.

Leland Burnettquot;Mike Woodardquot; wrote:

gt; Maybe one of these tricks apply to your situation...?
gt;
gt; 1) Have you tried selecting all of the sheets and CTRL F a portion of text
gt; from the name of the linked workbook? If your link is to bookxyz.xls, you
gt; can just look for all occurances of quot;xyzquot;.
gt; or
gt; 2) Do you have any named ranges? Try going to insert gt; name gt; define. If
gt; your workbook has named ranges that came from another book you can get a
gt; link notice upon opening.
gt;
gt; Best Regards,
gt; Mike
gt;
gt; quot;LTB @ Miami, OKquot; lt;LTB @ Miami, gt; wrote in
gt; message ...
gt; gt; When I open a workspace, I receive a dialogue box with a link listed in
gt; gt; the
gt; gt; dialogue box title bar. I am not able to find the link in any of the
gt; gt; active
gt; gt; workbooks within the workspace. Does anyone know how to locate the listed
gt; gt; links or eleminate the dialogue box?
gt;
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()