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

T

Tobias

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

Gordon

Tobias said:
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?
Click to expand...

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

paul

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"
 
T

Tobias

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

paul

"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.
 
Top