There is an old thread about this, but the Forum itself suggested I start a new one, so here goes.
Here's the old thread: Paste button grayed out
Also, I have been pursuing the issue in the Microsoft Office Forums - lots of ideas but absolutely no solution - so I hope its OK to try here ?
The issue involves copying from one workbook and pasting into another, and here are the circumstances and symptoms . . .
The workaround (using the Clipboard dialog) is too limited for me as I need to do some pasting using VBA.
Other helpers have opened my file and have reported that they can paste into it just fine, but also they don't have the same configuration as I do. The files came from Office 2010 on Wondows 7 where they continue to work OK.
I was going to give up looking for a fix, suspecting corruption or something like it, when I found the other thread in this forum reporting the exact same issue with Office 365 - but without a solution.
I suspect it is something to do with Office 365, maybe connected with Windows 11. I have gone through every setting I can find (a lot !) to no avail.
I'd be grateful for any help or ideas.
Martin
Here's the old thread: Paste button grayed out
Also, I have been pursuing the issue in the Microsoft Office Forums - lots of ideas but absolutely no solution - so I hope its OK to try here ?
The issue involves copying from one workbook and pasting into another, and here are the circumstances and symptoms . . .
- It is a new install of Office 365 on a new Windows 11 PC. There are no other issues with Office that I am aware of, execpt for an abstruse bug in Outlook concerning the indexing of contacts. I can't see that that's related to the present issue.
- There is no protection on the target workbook
- I can successfully COPY items - I see them on the Clipboard.
- I can paste TEXT into a cell, but I cannot paste a whole cell or range of cells, even though I can see the item on the Clipbaord dialog in the target workbook.
- This only seems to happen when the target workbook is an .xlsm file - or the same thing saved as .xlsb
- There are 4 ways to paste, as far as I know . . .
- CTRL V - this simply does nothing
- The Paste button on the ribbon - this is greyed out
- In a Macro - this returns an error "1004"
- Clicking the item in the Clipboard - this one works
The workaround (using the Clipboard dialog) is too limited for me as I need to do some pasting using VBA.
Other helpers have opened my file and have reported that they can paste into it just fine, but also they don't have the same configuration as I do. The files came from Office 2010 on Wondows 7 where they continue to work OK.
I was going to give up looking for a fix, suspecting corruption or something like it, when I found the other thread in this forum reporting the exact same issue with Office 365 - but without a solution.
I suspect it is something to do with Office 365, maybe connected with Windows 11. I have gone through every setting I can find (a lot !) to no avail.
I'd be grateful for any help or ideas.
Martin
Last edited by a moderator:
)
