You cut the range--that means that each of the formulas that used a cell in that
range that was cut has to point to the new location.

It works the same way if you cut and paste into the same worksheet.

What would you have excel do?

Maybe you could copy|paste and then clear the contents of the original range????

KSO wrote:

If you have a protected sheet in a workbook, A, and you CUT out some of the
unprotected cells from A and paste them in another workbook - then the
"protected" cells in A changes !!!!!!!!!

Sample:
Insert some dates in column A.
Insert formula in column B to extract the dayname from the date in column A.
Unprotect column A and protect the sheet.
Save the workbook

CUT out some cells in column A and insert thenm in new workbook B and save B

Look at the formulas in column B in workbook A - they have changed
!!!!!!!!!!!!!

It's a fatal ERROR I think !

How can this be avoided ?

--

Dave Peterson