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;
- Sep 23 Tue 2008 20:46
Workspace amp; Links referenced when workspace opened.
close
全站熱搜
留言列表
發表留言