Thread: [Solved] Cannot paste INTO a workbook
View Single Post
 
Old 05-31-2023, 01:18 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Advanced Beginner
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

That's a good idea - it is attached

It contains sensitive data so I've stripped everything out, and confirmed that the issue persists on the one empty worksheet which remains . . .

. . . If I copy a cell or a range of cells from another workbook, I cannot use CTRL V or the Paste command on the QAT. However the range to be pasted shows up on the Clipboard and can be pasted by clicking on it. At which point CTRL V and the Paste command come back to life, but can only be used to paste the same item.

Clearly I have a workaround but I'd love to get to the bottom of this !

PS In the next reply it was suggested that Macros were the problem. I have removed them all - and the problem persists. Anyway, I've attached the file without Macros.
Attached Files
File Type: xlsm Tree - Copy - no Macros.xlsm (60.9 KB, 3 views)

Last edited by MartinGM; 05-31-2023 at 04:12 AM.
Reply With Quote