Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #16  
Old 05-31-2023, 04:13 AM
MartinGM MartinGM is offline Cannot paste INTO a workbook Windows 11 Cannot paste INTO a workbook Office 2021
Advanced Beginner
Cannot paste INTO a workbook
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

Quote:
Originally Posted by rollis13 View Post
Hi to all.
To solve your issue you will have to work on the macros in the ThisWorkbook module.
I have removed all the code - the problem persists.
Reply With Quote
  #17  
Old 05-31-2023, 05:41 AM
MartinGM MartinGM is offline Cannot paste INTO a workbook Windows 11 Cannot paste INTO a workbook Office 2021
Advanced Beginner
Cannot paste INTO a workbook
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

I've removed all the macros - no difference
Reply With Quote
  #18  
Old 05-31-2023, 05:46 AM
kilroyscarnival kilroyscarnival is offline Cannot paste INTO a workbook Windows 10 Cannot paste INTO a workbook Office 2021
Expert
 
Join Date: May 2019
Posts: 344
kilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nicekilroyscarnival is just really nice
Default

Martin, I downloaded your attached file, and had no problem pasting data into it, even after I unblocked the macros and enabled them (I didn't actually find any macros).

I'm on Office 365.
Reply With Quote
  #19  
Old 05-31-2023, 06:29 AM
rollis13's Avatar
rollis13 rollis13 is offline Cannot paste INTO a workbook Windows 10 Cannot paste INTO a workbook Office 2016
Competent Performer
 
Join Date: Jan 2021
Location: Cordenons
Posts: 140
rollis13 will become famous soon enough
Default

Quote:
Originally Posted by MartinGM View Post
I have removed all the code - the problem persists.
OMG, this means that your Office is different from mine .
Reply With Quote
  #20  
Old 05-31-2023, 07:38 AM
MartinGM MartinGM is offline Cannot paste INTO a workbook Windows 11 Cannot paste INTO a workbook Office 2021
Advanced Beginner
Cannot paste INTO a workbook
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

Yes, it works for me with Excel 2010 but not with Excel 365 on Windows 11.

Just checking everything I can think of, I downloaded the attachment I uploaded to an earlier post and I cannot paste into it.

It looks like an Excel 365 issue ?
Reply With Quote
  #21  
Old 05-31-2023, 08:08 AM
Logit Logit is offline Cannot paste INTO a workbook Windows 10 Cannot paste INTO a workbook Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

I was able to paste into the workbook using several different methods ( Ctrl-V, Rt Click and Paste, The PASTE selections on the QAT ).

I suspect this specific file is somehow corrupt on your computer and should be rebuilt into a new workbook.
Reply With Quote
  #22  
Old 05-31-2023, 01:26 PM
MartinGM MartinGM is offline Cannot paste INTO a workbook Windows 11 Cannot paste INTO a workbook Office 2021
Advanced Beginner
Cannot paste INTO a workbook
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

Hmmm - when I download back the file I posted, I cannot paste into it.

Is it possible that Excel 365 is corrupt on my PC ?
Reply With Quote
  #23  
Old 05-31-2023, 07:06 PM
Logit Logit is offline Cannot paste INTO a workbook Windows 10 Cannot paste INTO a workbook Office 2007
Expert
 
Join Date: Jan 2017
Posts: 529
Logit is a jewel in the roughLogit is a jewel in the roughLogit is a jewel in the rough
Default

I'd guess most likely. Due to an upgrade patch usually.
Reply With Quote
  #24  
Old 06-02-2023, 02:12 AM
MartinGM MartinGM is offline Cannot paste INTO a workbook Windows 11 Cannot paste INTO a workbook Office 2021
Advanced Beginner
Cannot paste INTO a workbook
 
Join Date: May 2023
Location: England
Posts: 66
MartinGM is on a distinguished road
Default

Thanks for the all help and ideas.
I've marked this as "Solved" even though it isn't really - its just closed as I don't think there's any more I can do, and I have a reasonable workaround using the clipboard dialog.
I will however post here again if I ever get to the bottom of it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy a workbook to another workbook and keep the formatting within the new workbook excelforsue Excel 3 09-15-2020 03:37 AM
How does one copy paste to new workbook keeping formatting ? DBenz Excel 4 01-27-2020 04:55 AM
How can I copy a worksheet and paste values to another new workbook ? DBenz Excel 1 01-26-2019 07:03 AM
Cannot paste INTO a workbook Paste Excel chart with embeded workbook: PowerPoint for Mac 5amuel PowerPoint 1 02-16-2014 02:01 AM
paste graph between workbook/sheet sandsoppa Excel 2 02-25-2011 02:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:01 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft