Forum Discussion
llarson009
Apr 12, 2023Copper Contributor
HELP! I have over 100k Named Cells and Links to external files I cannot seem to find and break
Hello and HELP.
I have tried to maintain a clean file. However, a new employee copied tabs into a shared workbook, bringing in over 100k of named cells and about 10 links to external files.
The Name Manager doesn't open. The Break Links, doesn't work. I tried using a VBA (don't know what the code was anymore) to get ride of Named cells, said there wasn't enough memory. Break Links, can't find where the links are
- If the Name Manager add-in doesn't help, you can try the program here:
https://download.cnet.com/XLStylesTool-for-Windows-10/3000-2121_4-77579782.html
This mostly works on corrupt styles, but it can also give you some info on, and perhaps clean some of the problem named ranges
4 Replies
- Duke_CareyCopper ContributorIf the Name Manager add-in doesn't help, you can try the program here:
https://download.cnet.com/XLStylesTool-for-Windows-10/3000-2121_4-77579782.html
This mostly works on corrupt styles, but it can also give you some info on, and perhaps clean some of the problem named ranges- llarson009Copper Contributor
Duke_CareyThis worked... I processed my file and got it down to 18k in named cells and no external links. Love that this worked where so many others failed. So appreciate you sharing this with me!
Thanks lots!
Linda
- Detlef_LewinSilver Contributor
- llarson009Copper ContributorThis didn't work for me. Mostly because my company restricts macro used files. Maybe if that were not the case it would have worked. Thanks though!