I have created and tested a few examples of the master sheet where it links data from two base sheets.
The bases sheets are maintained by my team and I don't require any changes.
I have successfully done so but due to me testing a few times, the bases sheets are showing, each cell, data is outbound linked to <unknown Sheet>, these are the test sheets which I removed.
Question is how can I remove <unknown Sheets> links from each cell from two sheets which are about a thousand automatically?
Regards