Forum Discussion

llarson009's avatar
llarson009
Copper Contributor
Apr 12, 2023
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.

 

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_Carey's avatar
    Duke_Carey
    Copper Contributor
    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
    • llarson009's avatar
      llarson009
      Copper 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

    • llarson009's avatar
      llarson009
      Copper Contributor
      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!

Resources