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!
