Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-23-2015, 11:04 AM
dougdrex dougdrex is offline Need help with data links that seemingly cannot be broken Windows 7 64bit Need help with data links that seemingly cannot be broken Office 2010 64bit
Novice
Need help with data links that seemingly cannot be broken
 
Join Date: Nov 2014
Posts: 4
dougdrex is on a distinguished road
Default Need help with data links that seemingly cannot be broken

I'm using Excel 2010

The attached spreadsheet contains a data link that no longer exists (the file has been overwritten). However, when I go to Edit Links (in the Data tab), I am unable to break the data link.

There is VBA macro code, but I have looked and there doesn't appear to be any reference to the old spreadsheet. Any ideas on what is causing this, and how to fix it?

Thanks!


Doug
Attached Files
File Type: xlsm DataLinkIssue.xlsm (38.4 KB, 9 views)
Reply With Quote
  #2  
Old 04-24-2015, 05:36 AM
Catalin.B Catalin.B is offline Need help with data links that seemingly cannot be broken Windows Vista Need help with data links that seemingly cannot be broken Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

Hi Doug,
Usually, the links can be found not only in cells formulas. You should always check in the list of defined names, at list that's what i did.
There is a name: Analysis, which refers to: ='C:\Doug D\TPU Excel Forms\HRMP\[HRMP Questionnaire SmartForm.Macro.xlsm]Validations'!$F$2:$F$6
If the list in this workbook, remove the external link: Validations'!$F$2:$F$6
Also, links can "hide" in hyperlinks associated with shapes.
Cheers,
Catalin
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
broken links in excel documents kennystringer Excel 1 08-03-2013 12:26 PM
Work calculated differently for two seemingly identical tasks SteveD Project 0 10-12-2011 02:05 PM
Need help with data links that seemingly cannot be broken Macro to loop in subfolders, change links, export xml data Catalin.B Excel Programming 2 09-08-2011 11:37 PM
Broken links in Microsoft Word 2007 (Help Please!) Thomas_Anderson Word 0 09-24-2010 12:33 PM
links to excell broken after saving file mike.taylor2@hp.com PowerPoint 0 07-01-2010 02:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2022, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2022 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft