How do I Remove "Links?"

C

CliffoftheDesert

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!
 
G

Gordon

CliffoftheDesert said:
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!
Click to expand...

Get the utility at the top of this page:
http://www.acctadv.com/exceldownloads.php

HTH
 
C

CliffoftheDesert

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
 
D

Dave Peterson

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.
 
C

CliffoftheDesert

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 said:
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.

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
Click to expand...
Click to expand...
 
D

Dave Peterson

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.
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 said:
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.

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

:

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!
Click to expand...
Click to expand...
Click to expand...
 
C

CliffoftheDesert

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 said:
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.
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 said:
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

:

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!
Click to expand...
Click to expand...
Click to expand...
 
C

CliffoftheDesert

microsoft.public.mac.office.excel doesn't appear to be a working url, Dave.

Cliff


Dave Peterson said:
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.
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 said:
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

:

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!
Click to expand...
Click to expand...
Click to expand...
 
D

Dave Peterson

It's not a URL, it's a newsgroup.

How about:

news://msnews.microsoft.com/microsoft.public.mac.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?)
microsoft.public.mac.office.excel doesn't appear to be a working url, Dave.

Cliff

Dave Peterson said:
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.
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

:

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

:

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!
Click to expand...
Click to expand...
Click to expand...
 
C

CliffoftheDesert

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 said:
It's not a URL, it's a newsgroup.

How about:

news://msnews.microsoft.com/microsoft.public.mac.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?)
microsoft.public.mac.office.excel doesn't appear to be a working url, Dave.

Cliff

Dave Peterson said:
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

:

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

:

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!
Click to expand...
Click to expand...
Click to expand...
 
D

Dave Peterson

I see your post there. Glad you found a way to post it.

Here's hoping you get a good answer.
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 said:
It's not a URL, it's a newsgroup.

How about:

news://msnews.microsoft.com/microsoft.public.mac.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?)
microsoft.public.mac.office.excel doesn't appear to be a working url, Dave.

Cliff

:

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

:

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

:

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!
Click to expand...
Click to expand...
Click to expand...
 
C

CliffoftheDesert

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
 
D

Dave Peterson

Maybe time to "upgrade" to wintel <vbg>.
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
Click to expand...
 
C

CliffoftheDesert

Now why did I know that was coming? Nope. I'm a Mac guy, even with its
faults.

:)

Cliff
 
Top