We help IT Professionals succeed at work.

Excel 2010 Find the link ... "This workbook contains links to other sources"

biker9
biker9 asked
on
Medium Priority
3,041 Views
Last Modified: 2012-05-12
Hello Experts, I've attached a sheet that contains a link to another sheet. I would like to find the source. I have eliminated all the sheets and code, tried linking back to itself etc to no avail. So where is this hiding?

Hoping someone can find it so I can go back to my original sheet and fix it so this rather annoying message goes away. Simply suppressing the message would't be helpful since I do at times need to link to other sheets.

Thanks,
biker9
Find-Links.xlsm
Comment
Watch Question

I assumed that the file where the link is sourced is probably moved or deleted.

Sincerely,
Ed
If the link is not important, you may do the break the link option and then use the steps below to not display a message during startup.

1.On the Data tab, in the Connections group, click Edit Links.
2.Click Startup Prompt.
3.Click Don't display the alert and don’t update automatic links.

Sincerely,
Ed

Author

Commented:
Hi Ed,
the link has been moved,  I need the message to select other links so disabling it is not an option.
tx,
Ray
Rob HensonFinance Analyst
CERTIFIED EXPERT

Commented:
On some of the tabs you have some buttons with macros assigned to them. The macros are in a separate file so there is a link to the file containing the macros.

Thanks
Rob H

CERTIFIED EXPERT

Commented:
one example is in the conditional formatting on the Cashflows tab, about rule 95

- for reference I found it in this case by renaming the file to .zip then opening the xml and searching the sheets. normally I would use ASAP utilities.

HTH

Reg

Author

Commented:
Rob H, how did you find the buttons & macros etc, I thought I had deleted them from the sheets prior to sending it?
Tx,
Ray

CERTIFIED EXPERT

Commented:
the buttons are there but the macros have gone - check the holdco form for examples

Reg
Rob HensonFinance Analyst
CERTIFIED EXPERT
Commented:
Select all sheets, F5, Special, Objects, OK.

Thanks

Author

Commented:
I've gone through the workbook and deleted all the objects F5 Special etc, and received the "No Objects Found" for each sheet, and the link message persists.

Could you suggest a strategy or perhaps code that could cycle through the book and find the remaining links?
Ray

CERTIFIED EXPERT
Commented:
as I said earlier - its in the conditional formatting!!!!

regmigrant:one example is in the conditional formatting on the Cashflows tab, about rule 95

- for reference I found it in this case by renaming the file to .zip then opening the xml and searching the sheets. normally I would use ASAP utilities.

HTH

Reg

Author

Commented:
Reg, my apologies, yes I found the links by check the cond formats, thank you so much!.  I've got a number of sheets to fix, and since I don't know anything about xml, what utility in ASAP do you suggest to find the links buried within the conditional formatting?
Tx

Author

Commented:
Thanks again, I was able to go through the sheets and clear up the conditional formatting, that was the source of the problem. The sheet now loads without the links message.
Ray