Solved

Excel won't allow to break links...

Posted on 2016-09-14
4
76 Views
Last Modified: 2016-09-14
Hi Experts,

Excel won't allow to break links...

Thanks
0
Comment
Question by:Ayansane
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 95

Assisted Solution

by:John Hurst
John Hurst earned 50 total points
ID: 41799031
Right Click, Remove Hyperlink. Does that work?
0
 
LVL 47

Accepted Solution

by:
Wayne Taylor (webtubbs) earned 450 total points
ID: 41799093
Wrong links John. Breaking links refers to links to other data sources, not hyperlinks.

Ayansane, we're going to need a bit more information. Does it give any error messages when attempting to break links? What are the links to? All links or just some?
0
 

Author Closing Comment

by:Ayansane
ID: 41799182
Thx much...
0
 
LVL 26

Expert Comment

by:ProfessorJimJam
ID: 41799190
Sometimes , when you have a broken link inside a named range , then it will not break by breaking link, you need to remove the named range and then it will break
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question