Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I Remove "Links?"
I have a fairly large database in an Excel document that I've been working on
for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! |
#2
|
|||
|
|||
"CliffoftheDesert" wrote in
message ... I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! Get the utility at the top of this page: http://www.acctadv.com/exceldownloads.php HTH |
#3
|
|||
|
|||
When I can't find links, I'll use Bill Manville's FindLink program: http://www.oaltd.co.uk/MVP/Default.htm CliffoftheDesert wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson |
#4
|
|||
|
|||
I'm afraid that this is my fault, but I'm not able to open either of these
link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! |
#5
|
|||
|
|||
maybe you can use edit|Find and look for: .xls
If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson |
#6
|
|||
|
|||
I tried the search for .xls and none came up. Searching for open square
brackets was a bit of a problem, since they are used extensively throghout the document and have been all along. I looked at each, however, and didn't see anything that looked out of the ordinary. The problem still persists. Thanks. Cliff "Dave Peterson" wrote: maybe you can use edit|Find and look for: .xls If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson |
#7
|
|||
|
|||
Maybe asking in a Mac newsgroup would help.
microsoft.public.mac.office.excel I went to shareware.com and searched for zip on just the mac platform and got this hit: http://www.download.com/3000-2254-5040047.html But I'm not sure if Bill Manville's addin will work on a mac. If you get it extracted, can you post back with your results. CliffoftheDesert wrote: I tried the search for .xls and none came up. Searching for open square brackets was a bit of a problem, since they are used extensively throghout the document and have been all along. I looked at each, however, and didn't see anything that looked out of the ordinary. The problem still persists. Thanks. Cliff "Dave Peterson" wrote: maybe you can use edit|Find and look for: .xls If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson -- Dave Peterson |
#8
|
|||
|
|||
I appreciate your trying, Dave. I can extract zip files. That's not the
issue. But his add-in caused Excel to freeze, so it doesn't appear to be Mac compatible. Cliff "Dave Peterson" wrote: Maybe asking in a Mac newsgroup would help. microsoft.public.mac.office.excel I went to shareware.com and searched for zip on just the mac platform and got this hit: http://www.download.com/3000-2254-5040047.html But I'm not sure if Bill Manville's addin will work on a mac. If you get it extracted, can you post back with your results. CliffoftheDesert wrote: I tried the search for .xls and none came up. Searching for open square brackets was a bit of a problem, since they are used extensively throghout the document and have been all along. I looked at each, however, and didn't see anything that looked out of the ordinary. The problem still persists. Thanks. Cliff "Dave Peterson" wrote: maybe you can use edit|Find and look for: .xls If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson -- Dave Peterson |
#9
|
|||
|
|||
microsoft.public.mac.office.excel doesn't appear to be a working url, Dave.
Cliff "Dave Peterson" wrote: Maybe asking in a Mac newsgroup would help. microsoft.public.mac.office.excel I went to shareware.com and searched for zip on just the mac platform and got this hit: http://www.download.com/3000-2254-5040047.html But I'm not sure if Bill Manville's addin will work on a mac. If you get it extracted, can you post back with your results. CliffoftheDesert wrote: I tried the search for .xls and none came up. Searching for open square brackets was a bit of a problem, since they are used extensively throghout the document and have been all along. I looked at each, however, and didn't see anything that looked out of the ordinary. The problem still persists. Thanks. Cliff "Dave Peterson" wrote: maybe you can use edit|Find and look for: .xls If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson -- Dave Peterson |
#10
|
|||
|
|||
It's not a URL, it's a newsgroup.
How about: news://msnews.microsoft.com/microsof...c.office.excel If I paste it into MSIE, I get tossed into Outlook Express and see the newsgroup. I have no idea how it'll work on a Mac. (I don't visit the communities site, but isn't there a mac community on that CDO stuff?) CliffoftheDesert wrote: microsoft.public.mac.office.excel doesn't appear to be a working url, Dave. Cliff "Dave Peterson" wrote: Maybe asking in a Mac newsgroup would help. microsoft.public.mac.office.excel I went to shareware.com and searched for zip on just the mac platform and got this hit: http://www.download.com/3000-2254-5040047.html But I'm not sure if Bill Manville's addin will work on a mac. If you get it extracted, can you post back with your results. CliffoftheDesert wrote: I tried the search for .xls and none came up. Searching for open square brackets was a bit of a problem, since they are used extensively throghout the document and have been all along. I looked at each, however, and didn't see anything that looked out of the ordinary. The problem still persists. Thanks. Cliff "Dave Peterson" wrote: maybe you can use edit|Find and look for: .xls If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#11
|
|||
|
|||
No, that didn't work either, but I looked up Mac excel discussion groups on
google and it came up with a google group. I've posted to that and we'll see if I get a response. Thanks. Cliff "Dave Peterson" wrote: It's not a URL, it's a newsgroup. How about: news://msnews.microsoft.com/microsof...c.office.excel If I paste it into MSIE, I get tossed into Outlook Express and see the newsgroup. I have no idea how it'll work on a Mac. (I don't visit the communities site, but isn't there a mac community on that CDO stuff?) CliffoftheDesert wrote: microsoft.public.mac.office.excel doesn't appear to be a working url, Dave. Cliff "Dave Peterson" wrote: Maybe asking in a Mac newsgroup would help. microsoft.public.mac.office.excel I went to shareware.com and searched for zip on just the mac platform and got this hit: http://www.download.com/3000-2254-5040047.html But I'm not sure if Bill Manville's addin will work on a mac. If you get it extracted, can you post back with your results. CliffoftheDesert wrote: I tried the search for .xls and none came up. Searching for open square brackets was a bit of a problem, since they are used extensively throghout the document and have been all along. I looked at each, however, and didn't see anything that looked out of the ordinary. The problem still persists. Thanks. Cliff "Dave Peterson" wrote: maybe you can use edit|Find and look for: .xls If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#12
|
|||
|
|||
I see your post there. Glad you found a way to post it.
Here's hoping you get a good answer. CliffoftheDesert wrote: No, that didn't work either, but I looked up Mac excel discussion groups on google and it came up with a google group. I've posted to that and we'll see if I get a response. Thanks. Cliff "Dave Peterson" wrote: It's not a URL, it's a newsgroup. How about: news://msnews.microsoft.com/microsof...c.office.excel If I paste it into MSIE, I get tossed into Outlook Express and see the newsgroup. I have no idea how it'll work on a Mac. (I don't visit the communities site, but isn't there a mac community on that CDO stuff?) CliffoftheDesert wrote: microsoft.public.mac.office.excel doesn't appear to be a working url, Dave. Cliff "Dave Peterson" wrote: Maybe asking in a Mac newsgroup would help. microsoft.public.mac.office.excel I went to shareware.com and searched for zip on just the mac platform and got this hit: http://www.download.com/3000-2254-5040047.html But I'm not sure if Bill Manville's addin will work on a mac. If you get it extracted, can you post back with your results. CliffoftheDesert wrote: I tried the search for .xls and none came up. Searching for open square brackets was a bit of a problem, since they are used extensively throghout the document and have been all along. I looked at each, however, and didn't see anything that looked out of the ordinary. The problem still persists. Thanks. Cliff "Dave Peterson" wrote: maybe you can use edit|Find and look for: .xls If you have links to other workbooks that use .xls as an extension (do Mac's do this???) Or look for: [ (open square bracket) They're used in formulas that link to other workbooks, too. CliffoftheDesert wrote: I'm afraid that this is my fault, but I'm not able to open either of these link finders. It's my fault as I should have said at the outset that I use a Mac, and he Mac doesn't recognize these file types. Thank you both for trying though! Cliff "CliffoftheDesert" wrote: I have a fairly large database in an Excel document that I've been working on for the past three years. For the past week or so I've been getting a message every time I try to open the document saying "the workbook you opened contains automatic links to information in another workbook." If it does, it happened accidentally, for I never intended to link any other workbook. If I click on "Edit Links," I am then given the option to "Break Link." However, when I click on Break Link, it doesn't remove this phantom link and I'm given the same error message the next time I try to open the document. Any suggestions on how to get rid of this? Thanks! -- Dave Peterson -- Dave Peterson -- Dave Peterson -- Dave Peterson |
#13
|
|||
|
|||
Thanks again for all of your efforts, Dave. So far nothing there, and it
doesn't look like a very active forum. But we'll see. Cliff "Dave Peterson" wrote: I see your post there. Glad you found a way to post it. Here's hoping you get a good answer. |
#14
|
|||
|
|||
Maybe time to "upgrade" to wintel <vbg.
CliffoftheDesert wrote: Thanks again for all of your efforts, Dave. So far nothing there, and it doesn't look like a very active forum. But we'll see. Cliff "Dave Peterson" wrote: I see your post there. Glad you found a way to post it. Here's hoping you get a good answer. -- Dave Peterson |
#15
|
|||
|
|||
Now why did I know that was coming? Nope. I'm a Mac guy, even with its
faults. (: Cliff "Dave Peterson" wrote: Maybe time to "upgrade" to wintel <vbg. CliffoftheDesert wrote: Thanks again for all of your efforts, Dave. So far nothing there, and it doesn't look like a very active forum. But we'll see. Cliff "Dave Peterson" wrote: I see your post there. Glad you found a way to post it. Here's hoping you get a good answer. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reoccurring Edit Links Error | Excel Discussion (Misc queries) | |||
can't update links...can't find links | Excel Discussion (Misc queries) | |||
How do I remove external links from Excel 2000 workbook? | Excel Discussion (Misc queries) | |||
Does any one know how to globally remove links in an excel spread. | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |