Hi

I have a number of Workbooks used by others in my organisation.

Often they will copy cells that have range names from one workbook to another. In the end a workbook may have several instances of eth same range name but referencing different workbooks.

Can I prevent this from Occurring? I want to stop new instances of eth same range name from being added to the workbook.

And if cannot prevent this can I have a test in when using Combine and Transform Power Query to test if there is more than one instance of a range name in each of the files in a folder?

Thank You

Allister