Product that creates loads of named ranges in Excel

[Steve Rowe]

Hi,

I think I have asked this before but is anyone aware of an Excel add-in that creates vast (1,000s) of named ranges in Excel, often of the hidden variety?
This causes poor performance in Pafe (well worth checking the named ranges if you have slower than expected excel sheets).
One book has so many names in it that the Name Manager was crashing out and the Names object in VBA was crashing out with memory errors. I had to clean that up by "hacking" the Excel doc and directly editting the workbook.xml.

Annoying......it's possible (probable?) it is a very old product and these sheets have just been handed around and added / removed from sheets transferring the names from place, like some kind of old skool "toy" virus.

Named Ranges.png (51.96 KiB) Viewed 927 times

[ascheevel]

Doesn't Contributor create a bunch of named ranges?

[JohnO]

From memory SAP Bex Analyzer (Old Excel add-in) creates many styles but I don't know about named ranges. It caused performance degradation and we had to write some standard code to clear them out for users on a regular basis.