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.