+ Reply to Thread
Results 1 to 16 of 16

Paste function disabled / can't paste from another excel file

Hybrid View

  1. 11-13-2019, 06:21 PM #1
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Question Paste function disabled / can't paste from another excel file

    So I am having a weird issue. I have this particular excel file in which i can't paste anything from any other excel file. It appears paste button is disabled. I can copy and paste WITHIN the file without any issue BUT if i copy something from different excel file i can't paste. Paste function seems disabled. The only way to make paste work is by clicking on the arrow in the lower corner of clipboard (under home tab) which will open up clipboard side window and paste it from there (see uploaded photoAlternative way to paste.jpg). Also, this file require password to open - in case if this has anything do with it. All the sheets inside the workbook are not protected. I have tried copied and paste between all other excel files and they all work but only this particular file i am issue with. It doesn't have any macro or vba. Any idea what's causing this issue? Thank you for all the help i can get.
    Reply With QuoteRegister To Reply
  2. 11-13-2019, 10:27 PM #2
    JLGWhiz
    JLGWhiz is offline
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Paste function disabled / can't paste from another excel file

    Look in your ThisWorkbook code module and see if there is code to disable 'CutCopyAndPaste'. It would be in Workbook_Open, Workbook_BeforeSave and maybe one or two more Workbook macros. The code disables the keyboard shortcuts as well as the menu buttons. Before deleting the code, you might want to check around and find out why it was put there.
    Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
    Just when I think I am smart, I learn something new!
    Reply With QuoteRegister To Reply
  3. 11-14-2019, 09:47 AM #3
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    I am not sure if i am looking at right place but below i what i found under view code
    this workbook code.jpg

    Am i looking at right place? I can't find workbook_open or workbook_beforesave. Thank you for your help
    Reply With QuoteRegister To Reply
  4. 11-14-2019, 11:29 AM #4
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    attached is the file for your reference that is having issue.
    Attached Files Attached Files
    Last edited by vani2004; 11-14-2019 at 12:32 PM.
    Reply With QuoteRegister To Reply
  5. 11-14-2019, 11:38 AM #5
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: Paste function disabled / can't paste from another excel file

    No idea why you can't, but I can't as the file is password protected & I don't know the password.
    Reply With QuoteRegister To Reply
  6. 11-14-2019, 11:49 AM #6
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    I have removed the file and attached it again
    Last edited by vani2004; 11-14-2019 at 11:54 AM.
    Reply With QuoteRegister To Reply
  7. 11-14-2019, 11:54 AM #7
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    Here is the file that i am having issue with. i have removed the password.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  8. 11-14-2019, 12:36 PM #8
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: Paste function disabled / can't paste from another excel file

    I have no problems pasting into that workbook from another workbook. So not sure what to suggest.
    Reply With QuoteRegister To Reply
  9. 11-14-2019, 12:43 PM #9
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    Hmm...that's interesting because all of my coworker (at my current location and at our corporate office) they all having issues with pasting in this file. I wonder why?
    Reply With QuoteRegister To Reply
  10. 11-14-2019, 12:49 PM #10
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: Paste function disabled / can't paste from another excel file

    Is the original file an xlsx, or xlsm?
    Reply With QuoteRegister To Reply
  11. 11-14-2019, 02:05 PM #11
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    Original file is an .xlsx
    We are using office 2016
    Reply With QuoteRegister To Reply
  12. 11-14-2019, 12:58 PM #12
    JLGWhiz
    JLGWhiz is offline
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Paste function disabled / can't paste from another excel file

    Can you paste to it with the protection removed? You would not be able to paste to it from external source if it is protected.
    Last edited by JLGWhiz; 11-14-2019 at 01:03 PM.
    Reply With QuoteRegister To Reply
  13. 11-14-2019, 02:06 PM #13
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    Protection is on the workbook and not on the worksheet. I have removed protection on the workbook and then tried to paste into it and it still won't work. Copy and paste functions works within the workbook from one sheet to another sheet but just an issue when pasting into from another file.
    Reply With QuoteRegister To Reply
  14. 11-15-2019, 03:33 PM #14
    vani2004
    vani2004 is offline
    Registered User
    Join Date
    03-18-2014
    Location
    burlington, nj
    MS-Off Ver
    Excel 365
    Posts
    73

    Re: Paste function disabled / can't paste from another excel file

    Solved: I had two things that was checked marked under file/advance option (see attachment below). Once i unchecked this two items under lotus compatibility - i can now paste
    Attachment 649895
    Reply With QuoteRegister To Reply
  15. 11-15-2019, 03:45 PM #15
    Fluff13
    Fluff13 is offline
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,870

    Re: Paste function disabled / can't paste from another excel file

    Glad you solved it & thanks for the feedback
    Reply With QuoteRegister To Reply
  16. 11-16-2019, 12:57 PM #16
    JLGWhiz
    JLGWhiz is offline
    Forum Expert JLGWhiz's Avatar
    Join Date
    02-20-2011
    Location
    Florida, USA
    MS-Off Ver
    Windows 10, Excel 2013
    Posts
    2,070

    Re: Paste function disabled / can't paste from another excel file

    Interesting! I'll have to figure out how that impedes posting from external sources. Meanwhile, thanks for the information.
    Regards, JLG
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Right Mouse Click Cut,Copy & Paste Options disabled When ST3(Excel Utility) is Open
    By ITRestore in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2017, 01:03 AM
  2. How do I copy data from one file to another using VBA when copy/cut/paste disabled
    By osbornedj in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-28-2015, 04:24 PM
  3. Disabling paste options except paste values in a shared excel file
    By Alex.Mac in forum Excel General
    Replies: 3
    Last Post: 11-29-2014, 01:14 PM
  4. Copy excel data and paste it as picture in word file using paste special command
    By baluiyer in forum Excel General
    Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  5. Paste and Paste Special Functions Are Disabled. How to enable those again
    By lakshmisanthi in forum Excel General
    Replies: 4
    Last Post: 09-04-2012, 09:23 AM
  6. Paste disabled when toolbar is Hidden in Excel 2007
    By loknath in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-23-2012, 02:57 AM
  7. copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro
    By Steven in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-17-2005, 04:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1