Forum Discussion
Solved
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. ...
- 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
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
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
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