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 into the workbook I supplied. In the end a workbook may have several instances of the same range name but referencing different workbooks some of these on systems not available to me. When I use my Query it errors out because of such references.
Can I prevent the duplication of range names occurring. I want to stop new instances of the same range name from being added to the workbook?
And if cannot prevent this can I have a test when using Combine and Transform in my Power Query to test if there is more than one instance of a range name in each of the files in a folder?