Did this problem only appear in specific Workbooks?
Did the Workbooks contain formulas or VBA code?
How large did the Workbooks?
How did you copy and paste? Shortcut or right click?
I suggest you try to create 2 new Workbooks in desktop and check the result.
Then you can try to repair the Office: https://support.microsoft.com/en-us/office/repair-an-office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b
Please provide more information about the problem and I'm glad to help you.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.