I have recently migrated to Excel 365 - largely trouble-free but there's one thing I can no longer do . . .

I CAN copy part of a workbook and paste it elsewhere in the same workbook, or into another application.

But I CANNOT paste it into a different Excel workbook. CTRL V doesn't work and the Paste Special options are all greyed out.

I'm guessing this is due to a setting somewhere - does anyone have an idea whoich setting it might be ?

Thanks

PS I CAN paste text eg from a Note or a cell's contents, but I CANNOT paste a whoe cell or range of cells