• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Facing issue to break excel links

smittal

smittal

Member
Hi All,

I stucked at a place in excel from so long.

we have a excel workbook contain external links, I tried to break the links with all the options available in the Data Menu>>edits links.

I do good reserac on google as well and got options like:
1) Check Name Manager in formula and delete Range >> Checked and no range is available there.
2) Rebuild the excel:- :( no possible, bad idea to think, have extremely huge excel around 20 MB contains so much of graphics.

If someone can help me to sort the issue must be a breathe for me.

Thanks,
Smittal
 
Also:
Look in Charts for series linked to other workbooks
Look in Shapes for Hyperlinks
Look in Hyperlinks
 
Thanks all for suggestions but :( none of the worked out for me, checked all graphics series and data none of the chart/graph contained link, and try to find with "[" but output shows no data found.

My more reasons which stops me to break the link.
 

Attachments

  • upload_2015-12-11_15-42-29.png
    upload_2015-12-11_15-42-29.png
    514.8 KB · Views: 15
  • upload_2015-12-11_15-46-8.png
    upload_2015-12-11_15-46-8.png
    160.6 KB · Views: 12
Did you look in the Data Sources for each Pivot Table?

Are there any Remote Connections, goto Data, Connections tab
 
@smittal
What kind of message do You get about 'broken link'?
Do You have checked from all sheets (and without any protections)?
 
Last edited:
@ Deepak, its 12 MB file after zipped. have very less data and lots of graphics. Its good to share?
 
You must log in or register to reply here.
Back
Top