I've tried everything I can think of to break a link Excel tells me I have. The break links feature doesn't do it, I've searched all cells for the particular link and can't find it, and I've gone through all my defined names. Can anyone figure out how to remove the link in the attached workbook?
Texas PACE Authority Project Pro Forma v2.22A.xlsm
So far, I've isolated the link to the Dashboard tab.
If you delete all other tabs....the links still exist.
If you delete only the Dashboard tab...the links are eliminated.
However. even after deleting all rows, all columns, all objects, all VBA modules, and all range names...the links still exist!
I'm guessing that tab is corrupted in some obscure way.
Follow-up...This seems to work:
• MOVE the Dashboard tab to a new workbook
• MOVE the Dashboard tab from the new workbook back to the original workbook.
All functionality seems to be retained and there are no links.
Is that something you can work with?
Awesome! I'll try this and see if it works!
Ron, I've just tried this twice, but the link still seems to be there. Perhaps you can upload the unlinked spreadsheet you created?
I'll have to wait until I get home.
If I attach files at work...I get a newspaper over the snout!
Hmmm...I just noticed you're on a Mac.
I wonder if that's one of the differences between Excel PC and Excel Mac.
I opened the file from your post and followed the instructions I posted...Links gone.
I tried it on a PC as well, and couldn't get it to work, so I don't think it was the Mac issue. Maybe I'll try it with a different computer?
Last edited by jblack6572; 09-24-2015 at 04:42 PM.
Re: Break Links Not working
OK I've now tried this on two different PCs and the link is still there. To be clear, I move to a new workbook, move back, and then when I click the "edit links" button, the link is still listed. Do you have a magic computer?
If it really does work for you, would you mind uploading and I'll just use that one?
Thanks,
Jonathon
Ok...now I'm confused.
the process I posted was actually successful...at work...using Excel 2007.
When I tried it at home...Excel 2010 AND Excel 2013...it fails. (sorry)
Cell E13 of Dashboard contains a Data Validation link to an older version of the spreadsheet. Fix that, save and re-open. That should do it.
Nice catch!
This situation prompted me to write a macro that I've been meaning to get to for quite some time.
This code
• inserts a new worksheet in the current workbook
• Identifies every DV cell in the active sheet
• On the new sheet, it lists:
...cell address
...DV Type
...Formula1
...Formula2
Note: That's just "quick and dirty" code..It's not especially comprehensive or elegant and has meager error checking....but it does what I want it to do (for now).
Please Login or Register to view this content.
Last edited by Ron Coderre; 09-25-2015 at 08:01 AM.
Big thanks to Ron Coderre, albeit 6 years later, helped us out of a tricky hole, macro works an absolute treat.
Can confirm 2022 macro still works - thank you!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks