ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Workspace & Links referenced when workspace opened. (https://www.excelbanter.com/excel-worksheet-functions/75819-workspace-links-referenced-when-workspace-opened.html)

LTB @ Miami, OK

Workspace & Links referenced when workspace opened.
 
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?

Mike Woodard

Workspace & Links referenced when workspace opened.
 
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 "xyz".
or
2) Do you have any named ranges? Try going to insert name define. If
your workbook has named ranges that came from another book you can get a
link notice upon opening.

Best Regards,
Mike

"LTB @ Miami, OK" <LTB @ Miami, wrote in
message ...
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?




LTB @ Miami, OK

Workspace & Links referenced when workspace opened.
 
Thanks Mike,

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

Leland Burnett


"Mike Woodard" wrote:

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 "xyz".
or
2) Do you have any named ranges? Try going to insert name define. If
your workbook has named ranges that came from another book you can get a
link notice upon opening.

Best Regards,
Mike

"LTB @ Miami, OK" <LTB @ Miami, wrote in
message ...
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?






All times are GMT +1. The time now is 04:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com