Afternoon all

I have a sheet, say Sheet 1, which has no formulas or macros; but is
referenced by a whole host of other sheets in the workbook which use the data
in Sheet 1 to provide the user with a load of useful stuff.

If (or when) the users use 'Edit Cut' in Sheet 1 moving data around, the
formulas in the sheets referencing Sheet 1 try to upate their references and
I'm left with #REF erorrs everywhere.

Is there a way around the default 'Cut' functionality or a way to preserve
the formula references so that this doesn't happen?

Best regards,
DanF