Excel creating random named ranges in error

[lwe2019]

Hi

We've had a weird problem where excel seems to create hundreds of random named ranges in files which have NO named ranges. It's only happened three times and all of those times it happened on files which were linked to other files but it also doesn't always happen so I am not sure what's causing it.

Any ideas?

 

[Yongle]

Unless specifically directed otherwise, VBA generally acts on the active sheet and the active workbook
Perhaps the "wrong" workbook is sometimes active when those Named Ranges are being auto-created

If that is the cause - find the workbook which creates those named ranges and tighten up the code

 

[jkpieterse]

Copying a range of cells from a workbook with lots of named ranges may copy range names as well, depending on what the copied cells contain and whether or not any named ranges refer to those cells. SO I would inspect the source workbook as well.