...just plain old cut and paste. The workbooks were old...likely created under an older version of Excel. I've just finished a fairly large new workbook with no problems. I'll try the paste special/formulas/all next time it acts up. The sheets are related to income tax so there will be plenty of opportunity for the problem to reoccur in the next few weeks.