Hello,
Please try this function https://www.extendoffice.com/product/kutools-for-excel/excel-list-break-links.html
And then go to copy the formulas?

Thanks Jay, but I cannot get this fix to work either. Using the KuTools 'Find and break links' only does what happened previously - the copied formula (which can be either a direct copy-and-paste - which includes the address of the original spreadsheet, or when I copy the desired formula by highlighting it alone and copying this) just disappears from the new cell.

It may help if I show an example:

Direct copy-and-paste: =IFERROR(IF(ABS(CORREL('[CancerData _01Sep07Onwards -No CondFormatting.xlsm]NormData'!B$14:B$3802,'[CancerData _01Sep07Onwards -No CondFormatting.xlsm]NormData'!$MR$13:$MR$3801))>'[CancerData _01Sep07Onwards -No CondFormatting.xlsm]Raw Data'!$B$3816,SLOPE('[CancerData _01Sep07Onwards -No CondFormatting.xlsm]NormData'!B$14:B$3802,'[CancerData _01Sep07Onwards -No CondFormatting.xlsm]NormData'!$MR$13:$MR$3801),""),"")

But if I copy the formula of the original cell by highlighting it, I get this in the target cell (which is what I really want, but not to then disappear when I break the link, as the above does too): =IFERROR(IF(ABS(CORREL(NormData!B$14:B$3802,NormData!$MR$13:$MR$3801))>'Raw Data'!$B$3816,SLOPE(NormData!B$14:B$3802,NormData!$MR$13:$MR$3801),""),"")

The latter is the formula I wish to have in my new spreadsheet (and I have lots of them), but breaking the linkage results in that formula now disappearing.

I hope this is clear, and that you may have an alternative way of copying my original formulas into the new spreadsheet which enables it to remain when the linkage is broken.

Hello,
but breaking the linkage results in that formula now disappearing.
Do you only want the results of the formula after moving the formula?
If yes, please go to copy and paste the formula into new workbooks, and then go to use this function to convert the formula's result into value only.
This function: https://www.extendoffice.com/product/kutools-for-excel/excel-replace-formula-with-value-result.html
If you want to keep the formula and the formula's result after breaking links, we don't have function for such operation.

Thanks Jay for getting back to me.

It is the latter I wish - having generated a complex set of formulas in one spreadsheet, I want to just use the identical formulas in a different spreadsheet. I'll just have to think of another method.

Hello,

You may try this https://www.extendoffice.com/product/kutools-for-excel/excel-auto-text.html

Hi Jay,

Thanks for that attempt at a solution.

Alas, when I do as you suggest, I still find the formula in the new spreadsheet has the link to the original one. So that isn't what I need.

Also, it would be one cell at a time, rather than a range; and so would be laborious. I may as well do this manually then.

However, I appreciate you working on my problem.

Kind regards, Ian