Thread: [Solved] Cannot paste INTO a workbook
View Single Post
 
Old 05-30-2023, 10:42 AM
MartinGM MartinGM is offline Windows 11 Office 2021
Competent Performer
 
Join Date: May 2023
Location: England
Posts: 110
MartinGM is on a distinguished road
Default

I'm still trying to get this to work !

I have narrowed down the problem - it only occurs when I try to paste into specific .xlsm workbooks.
Pasting works OK into any .xlsx workbook

Maybe something to do with the macro settings in the affected workbooks ? They were all migrated form Excel 2010. I have tried a fresh "save as" but that has made no difference.

PS1 I can paste a group of cells from one worksheet to another within a .xlsm workbook, but not into another .xlsm workbook
PS2 As I said earlier, I can paste text into a .xlsm workbook, but not whole cells
Reply With Quote