ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   break links not working (https://www.excelbanter.com/excel-discussion-misc-queries/261254-break-links-not-working.html)

[email protected]

break links not working
 
On Monday, August 27, 2012 at 2:31:05 PM UTC+10, wrote:
You may please try the following:

Undder the formula bar, click name manager and delete the names and then give try.
I hope it will work.


Thank you for the "name manager" tip. Those links were driving me crazy!

I am working with a workbook that was created by someone else on another computer that has no connection to mine. I kept getting a links warning every time I opened the workbook. I tried "break links" and nothing changed. I tried copying and pasting only the values and the links remained. But when I went to "name manager" I saw 3 names that referenced workbooks with invalid file paths because they are on the computer that originally created my workbook. I deleted those names and the hated links warnings are gone!

[email protected]

break links not working
 
On Monday, August 27, 2012 at 8:31:05 AM UTC+4, wrote:
You may please try the following:

Undder the formula bar, click name manager and delete the names and then give try.
I hope it will work.


Worked.

Thanks

[email protected]

break links not working
 
In my case I found it to be a validation list which referenced to another workbook. Thank you guys for the idea to search there. I doubt I would have found it if it hadn't been for the input of those on this site.

Thanks.

Mac.

[email protected]

break links not working
 
http://watchtvpc.com/cormier-vs-jones-2-live/



http://watchtvpc.com/cormier-vs-jones-2-live/


All times are GMT +1. The time now is 01:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com