Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Microsoft Excel cannot paste the data.

    Ever since i upgraded from 03 to 10, i started gettting these annoying errors. Now I was sure it was a version control thing that i was experiencing because my sheets were created in 03 under an .xls. So i saved my files as .xlsm and i'm still getting the errors. annoying because i'm so using to CTRL-C and CTRL-V and i can't do that between these files. is there a blanket fix that i can do?
    thanks
    christine

  2. #2
    3 Star Lounger
    Join Date
    Nov 2002
    Location
    New York, New York, USA
    Posts
    266
    Thanks
    0
    Thanked 19 Times in 19 Posts
    Christine:

    I had a similar problem with Excel 2003 going from Workbook to Workbook.

    I was given a great solution from another Forum so I take zero credit

    Try the following VBA code before you open the workbooks, " Application.EnableEvents = False"
    Then try the copy and paste.

    But remember once you have completed all your copy and paste to run the VBA Code Application.EnableEvents = True

    The only othe solution is to start excel with no add-ins and see if you can copy and paste. If yes, activate each add-in until the problem occurs, which will identify the add-in. Then disable that add-in when you need to copy and paste between workbooks.

    Hope the above is some assistance.

    DuthieT

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    When you first save a workbook in the new 2007 (and later) format from an xls, it remains in compatibility mode until you close and reopen it. Perhaps that is the cause of the problem?
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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