Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LTB @ Miami, OK
 
Posts: n/a
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Woodard
 
Posts: n/a
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LTB @ Miami, OK
 
Posts: n/a
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
options to update automatic links Werner Rohrmoser Excel Worksheet Functions 0 November 10th 05 12:58 PM
Prompt to update links Werner Rohrmoser Links and Linking in Excel 0 November 3rd 05 09:47 AM
Deleting links to other spreadsheets KarenH Excel Worksheet Functions 2 October 28th 05 04:09 AM
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Links to other sheets only work if the sheet is opened Arnold de Lange Excel Discussion (Misc queries) 3 December 28th 04 03:12 PM


All times are GMT +1. The time now is 12:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"