Product that creates loads of named ranges in Excel
Posted: Tue Feb 07, 2023 5:28 pm
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.
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 1006 times