Hi

I sometimes have to copy a sheet to a different workbook, but the destination workbook is otherwise identical to the source workbook, so I don't need the sheet to keep links back to it's source.

To remove the links I simply select data menu/edit links and change them to the new workbook. The old links then disappear.

However this doesn't remove the links for data verification lists if they point at a range of cells. These continue to point at the source workbook. So I have to go through and manually change them.

Is there also a way to alter all these old references in one go please?

Thanks
Robin