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
This 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!