+ Reply to Thread
Results 1 to 7 of 7

Can't Copy and Paste or Paste Special between Excel Workbooks

  1. #1
    wllee
    Guest

    Can't Copy and Paste or Paste Special between Excel Workbooks

    We have a number of Excel users in our office who cannot copy and paste
    between Excel workbooks. They can copy and paste between worksheets. When
    you highlight the section to copy and then go to the new workbook both the
    paste
    and paste special are "grayed out". This is true whether you right-click the
    mouse, go to the edit menu, or use control keys. This occurs with any data
    type and the most simple workbooks. I have seen some suggestions here but
    none have worked for this particular problem. I have reset the menus and
    renamed the .xlb files and neither helps. You can open the clipboard and the
    paste will work, but there is no paste special option. Any help would be
    greatly appreciated. Thanks!


  2. #2
    Forum Contributor kraljb's Avatar
    Join Date
    05-26-2004
    Location
    Illinois
    MS-Off Ver
    2007 (recent change)
    Posts
    256
    When that has happened with me it is because Excel is actually running two different instances, try opening both workbooks through the same instance of Excel and see if that fixes the problem

  3. #3
    Registered User
    Join Date
    04-05-2005
    Posts
    15

    Can't Copy and Paste or Paste Special between Excel Workbooks Reply to Thread

    Check the version of Excel each workbook has been saved as (should all be Workbooks (*.xls)), generally if it has been saved as say Excel 5.0 then the paste special function may not have been available and hence is greyed out.

    Badger

  4. #4
    Ron de Bruin
    Guest

    Re: Can't Copy and Paste or Paste Special between Excel Workbooks

    Do you have the same problem when you open excel in Safe modus

    Try opening Excel without any Add-ins or hidden workbooks:
    Start>Run
    "C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
    Or Excel.exe /Safe


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "wllee" <wllee@discussions.microsoft.com> wrote in message news:215BD98C-7475-45EF-A474-6926A14CA30D@microsoft.com...
    > We have a number of Excel users in our office who cannot copy and paste
    > between Excel workbooks. They can copy and paste between worksheets. When
    > you highlight the section to copy and then go to the new workbook both the
    > paste
    > and paste special are "grayed out". This is true whether you right-click the
    > mouse, go to the edit menu, or use control keys. This occurs with any data
    > type and the most simple workbooks. I have seen some suggestions here but
    > none have worked for this particular problem. I have reset the menus and
    > renamed the .xlb files and neither helps. You can open the clipboard and the
    > paste will work, but there is no paste special option. Any help would be
    > greatly appreciated. Thanks!
    >




  5. #5
    wllee
    Guest

    Re: Can't Copy and Paste or Paste Special between Excel Workbooks

    I just tried what you suggested and I do not have the same problems. What
    should I check next. I really appreciate your time.

    Bill

    "Ron de Bruin" wrote:

    > Do you have the same problem when you open excel in Safe modus
    >
    > Try opening Excel without any Add-ins or hidden workbooks:
    > Start>Run
    > "C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
    > Or Excel.exe /Safe
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    >
    > "wllee" <wllee@discussions.microsoft.com> wrote in message news:215BD98C-7475-45EF-A474-6926A14CA30D@microsoft.com...
    > > We have a number of Excel users in our office who cannot copy and paste
    > > between Excel workbooks. They can copy and paste between worksheets. When
    > > you highlight the section to copy and then go to the new workbook both the
    > > paste
    > > and paste special are "grayed out". This is true whether you right-click the
    > > mouse, go to the edit menu, or use control keys. This occurs with any data
    > > type and the most simple workbooks. I have seen some suggestions here but
    > > none have worked for this particular problem. I have reset the menus and
    > > renamed the .xlb files and neither helps. You can open the clipboard and the
    > > paste will work, but there is no paste special option. Any help would be
    > > greatly appreciated. Thanks!
    > >

    >
    >
    >


  6. #6
    Ron de Bruin
    Guest

    Re: Can't Copy and Paste or Paste Special between Excel Workbooks

    Hi Bill

    It is either an add-in or a (hidden) workbook that is
    Loaded upon XL's start, which is causing problems.
    Tools-Addins and uncheck all Addins.
    Write down which ones were selected.
    Now close Excel and then reopen.

    If it is working then one of the Addins was causing the problem.
    Add them back one at a time, closing and opening Excel each time until you find it.

    If this didn't stop the problem, then the problem is a file in your xlStart directory.
    Any file in there Is loaded when you start Excel.
    Remove the files out of that folder and open Excel to see if the problem is gone.
    If it is then add them back one at a time, closing and opening Excel each time until you find it


    --
    Regards Ron de Bruin
    http://www.rondebruin.nl



    "wllee" <wllee@discussions.microsoft.com> wrote in message news:9048F1C0-7214-41C1-A851-0350590D0AF5@microsoft.com...
    >I just tried what you suggested and I do not have the same problems. What
    > should I check next. I really appreciate your time.
    >
    > Bill
    >
    > "Ron de Bruin" wrote:
    >
    >> Do you have the same problem when you open excel in Safe modus
    >>
    >> Try opening Excel without any Add-ins or hidden workbooks:
    >> Start>Run
    >> "C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
    >> Or Excel.exe /Safe
    >>
    >>
    >> --
    >> Regards Ron de Bruin
    >> http://www.rondebruin.nl
    >>
    >>
    >>
    >> "wllee" <wllee@discussions.microsoft.com> wrote in message news:215BD98C-7475-45EF-A474-6926A14CA30D@microsoft.com...
    >> > We have a number of Excel users in our office who cannot copy and paste
    >> > between Excel workbooks. They can copy and paste between worksheets. When
    >> > you highlight the section to copy and then go to the new workbook both the
    >> > paste
    >> > and paste special are "grayed out". This is true whether you right-click the
    >> > mouse, go to the edit menu, or use control keys. This occurs with any data
    >> > type and the most simple workbooks. I have seen some suggestions here but
    >> > none have worked for this particular problem. I have reset the menus and
    >> > renamed the .xlb files and neither helps. You can open the clipboard and the
    >> > paste will work, but there is no paste special option. Any help would be
    >> > greatly appreciated. Thanks!
    >> >

    >>
    >>
    >>




  7. #7
    wllee
    Guest

    Re: Can't Copy and Paste or Paste Special between Excel Workbooks

    Thanks very much for your time, I have figured it out. It was an
    obetexcelvbacommon addin that was causing the problem or actually the lack of
    it.

    Thanks again,

    Bill

    "Ron de Bruin" wrote:

    > Hi Bill
    >
    > It is either an add-in or a (hidden) workbook that is
    > Loaded upon XL's start, which is causing problems.
    > Tools-Addins and uncheck all Addins.
    > Write down which ones were selected.
    > Now close Excel and then reopen.
    >
    > If it is working then one of the Addins was causing the problem.
    > Add them back one at a time, closing and opening Excel each time until you find it.
    >
    > If this didn't stop the problem, then the problem is a file in your xlStart directory.
    > Any file in there Is loaded when you start Excel.
    > Remove the files out of that folder and open Excel to see if the problem is gone.
    > If it is then add them back one at a time, closing and opening Excel each time until you find it
    >
    >
    > --
    > Regards Ron de Bruin
    > http://www.rondebruin.nl
    >
    >
    >
    > "wllee" <wllee@discussions.microsoft.com> wrote in message news:9048F1C0-7214-41C1-A851-0350590D0AF5@microsoft.com...
    > >I just tried what you suggested and I do not have the same problems. What
    > > should I check next. I really appreciate your time.
    > >
    > > Bill
    > >
    > > "Ron de Bruin" wrote:
    > >
    > >> Do you have the same problem when you open excel in Safe modus
    > >>
    > >> Try opening Excel without any Add-ins or hidden workbooks:
    > >> Start>Run
    > >> "C:\Program Files\Microsoft Office\Office\Excel.exe" /Safe
    > >> Or Excel.exe /Safe
    > >>
    > >>
    > >> --
    > >> Regards Ron de Bruin
    > >> http://www.rondebruin.nl
    > >>
    > >>
    > >>
    > >> "wllee" <wllee@discussions.microsoft.com> wrote in message news:215BD98C-7475-45EF-A474-6926A14CA30D@microsoft.com...
    > >> > We have a number of Excel users in our office who cannot copy and paste
    > >> > between Excel workbooks. They can copy and paste between worksheets. When
    > >> > you highlight the section to copy and then go to the new workbook both the
    > >> > paste
    > >> > and paste special are "grayed out". This is true whether you right-click the
    > >> > mouse, go to the edit menu, or use control keys. This occurs with any data
    > >> > type and the most simple workbooks. I have seen some suggestions here but
    > >> > none have worked for this particular problem. I have reset the menus and
    > >> > renamed the .xlb files and neither helps. You can open the clipboard and the
    > >> > paste will work, but there is no paste special option. Any help would be
    > >> > greatly appreciated. Thanks!
    > >> >
    > >>
    > >>
    > >>

    >
    >
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1