I found a utility (Excel sheet copier) to transfer a template worksheet to multiple workbooks located in a common folder. The problem is that I now have 250+ successfully transferred workbook/worksheets with all the source links intact.
I know one can use (2010) Data > Edit > Links (select link source) > Change Source to remove the external links one workbook at a time.
Is there a way (macro?) to batch break the links to the source on all 250 transferred worksheets?
Thanks
I know one can use (2010) Data > Edit > Links (select link source) > Change Source to remove the external links one workbook at a time.
Is there a way (macro?) to batch break the links to the source on all 250 transferred worksheets?
Thanks