1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to deal with defined names

I have an excel file with 100s if not 1000s of defined names. I need to rid them all. Whenever I try to mass delete them in name manager my excel crashes. Any tips? This isn’t the first time I’ve had to do this and it takes wayyy more time than it probably should. Thanks

submitted by /u/OscarFromSharkTales
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel compatibility
#Excel alternatives for data analysis
#real-time data collaboration
#rows.com
#financial modeling with spreadsheets
#defined names
#excel file
#name manager
#mass delete
#crashes
#delete
#time-consuming
#tips
#hundreds
#thousands
#mass
#efficiency
#issues
#reduce
#performance