How can I find automatic links in an Excel-sheet?
 

I have an Excel-sheet with "automatic links" to other workbooks. At least
according to Excel, so every time when I open the document I have to click
'No' to the questions whether I want to update these. The problem is I can
not find this/these automatic link/s. Is there a way to find all automatic
links so that I can delete them?

Tobias wrote:
I have an Excel-sheet with "automatic links" to other workbooks. At
least according to Excel, so every time when I open the document I
have to click 'No' to the questions whether I want to update these.
The problem is I can not find this/these automatic link/s. Is there a
way to find all automatic links so that I can delete them?

Take a look he
http://www.acctadv.com/exceldownloads.php

next time you go into the sheet and you get the message go to the edit menu
and the "links" choice should be available.click on that and then you can
"break links"
--
paul
remove nospam for email addy!



"Tobias" wrote:

I have an Excel-sheet with "automatic links" to other workbooks. At least
according to Excel, so every time when I open the document I have to click
'No' to the questions whether I want to update these. The problem is I can
not find this/these automatic link/s. Is there a way to find all automatic
links so that I can delete them?

Hi Thanks both of you. It is now solved.

I couldn't however break the links from the Edit menu, it was not possible
to do anything but open the file (which didn't existed there anymore).
Instead I did find another add-in (dellink.xla) in a thread below which
worked perfectly well. So now my workbook can be opened without first
answering that question.


"paul" wrote:

next time you go into the sheet and you get the message go to the edit menu
and the "links" choice should be available.click on that and then you can
"break links"
--
paul
remove nospam for email addy!



"Tobias" wrote:

I have an Excel-sheet with "automatic links" to other workbooks. At least
according to Excel, so every time when I open the document I have to click
'No' to the questions whether I want to update these. The problem is I can
not find this/these automatic link/s. Is there a way to find all automatic
links so that I can delete them?

"the "links" choice should be available"
thats why i said should.......I have had that too and cant remember how i
fixed it.Glad you got it solved.
--
paul
remove nospam for email addy!



"Tobias" wrote:

Hi Thanks both of you. It is now solved.

I couldn't however break the links from the Edit menu, it was not possible
to do anything but open the file (which didn't existed there anymore).
Instead I did find another add-in (dellink.xla) in a thread below which
worked perfectly well. So now my workbook can be opened without first
answering that question.


"paul" wrote:

next time you go into the sheet and you get the message go to the edit menu
and the "links" choice should be available.click on that and then you can
"break links"
--
paul
remove nospam for email addy!



"Tobias" wrote:

I have an Excel-sheet with "automatic links" to other workbooks. At least
according to Excel, so every time when I open the document I have to click
'No' to the questions whether I want to update these. The problem is I can
not find this/these automatic link/s. Is there a way to find all automatic
links so that I can delete them?