Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default The Workbook you opened contains automatic links

I've seen several postings on how to remove the message about the
workbook containing automatic links, but what does this mean?

How do I find where these automatic links are? I just want to remove
the links.

Can someone give me some history on this? What are "links"? How do I
find them? How do I get rid of them?

Thanks.

Dennis Hancy
Eaton Corporation
Cleveland, OH

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 244
Default The Workbook you opened contains automatic links

Links are basically references to other workbooks - various ways of
getting rid of them, but it MAY be worth finding out why they are
present in the first place! However, replace formulas with values, use
the edit menu to get to the links and set the reference to the active
workbook, use the edit menu to FIND and replace the offending links.

wrote:
I've seen several postings on how to remove the message about the
workbook containing automatic links, but what does this mean?

How do I find where these automatic links are? I just want to remove
the links.

Can someone give me some history on this? What are "links"? How do I
find them? How do I get rid of them?

Thanks.

Dennis Hancy
Eaton Corporation
Cleveland, OH


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35,218
Default The Workbook you opened contains automatic links

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

" wrote:

I've seen several postings on how to remove the message about the
workbook containing automatic links, but what does this mean?

How do I find where these automatic links are? I just want to remove
the links.

Can someone give me some history on this? What are "links"? How do I
find them? How do I get rid of them?

Thanks.

Dennis Hancy
Eaton Corporation
Cleveland, OH


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default The Workbook you opened contains automatic links

Thanks for your replies!

I found my problem. I went to Insert/Name/Define, and found several
names there with references to URLs. How they got there, I haven't a
clue. But I removed them, and life is good.

Thanks again for your help.


Dennis


Dave Peterson wrote:
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

" wrote:

I've seen several postings on how to remove the message about the
workbook containing automatic links, but what does this mean?

How do I find where these automatic links are? I just want to remove
the links.

Can someone give me some history on this? What are "links"? How do I
find them? How do I get rid of them?

Thanks.

Dennis Hancy
Eaton Corporation
Cleveland, OH


--

Dave Peterson


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
Automatic links message when opening a workbook pgarcia Excel Discussion (Misc queries) 2 March 8th 07 10:53 PM
Removing automatic links to information in another workbook Sameer Excel Discussion (Misc queries) 1 October 4th 06 02:10 PM
Automatic links to another workbook justaguyfromky Excel Programming 3 March 19th 06 06:54 PM
automatic links displayalert when you open workbook funkymonkUK[_107_] Excel Programming 2 March 18th 06 10:24 PM
workbook contains automatic links T-Rex[_3_] Excel Programming 1 November 16th 04 02:42 AM


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

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

About Us

"It's about Microsoft Excel"