I have a workbook bloated with named ranges but when I click name manager I am unable to open the name manager. When I go to run any of the VBA scripts to delete name ranges including hidden ranges, it gives me a runtime error & out of memory. I am able to run any other VBA script.
Is there a way to repair this workbook and clean out all of the unwanted name ranges?
Can you upload a redacted version of the file?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Yes will take a little bit of time to redact but should be able to.
Unfortunately it will not allow me to upload the file even if it is zipped.
What size is the file? Can you delete anything? Half of each sheet maybe? That should leave the Named Ranges intact.
Perhaps save it as .xlsb. Just delete enough to reduce the size (of an .xlsb file) to less than 9.77Mb.
Failing that, can you put it on OneDrive or other cloud storage and post a link? If you do that, you might need to break the link up with spaces as you are a new user.
Have you tried doing an Office/Excel repair?
Or maybe try opening it in LibreOffice. That's free to download. Just a punt as I don't know how LO handles Named Ranges.
Actually was able to troubleshoot it based on this. Pulled a blank tab out and the name manager opened for that blank tab workbook. Found the 3 offending tabs and deleted them. Now i am actually able to delete the names out. All 41k of them.Originally Posted by TMS
No wonder Name Manager was struggling.All 41k of them.
Glad you got it sorted.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks