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!

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

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

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" <[email protected]> wrote in message news:[email protected]...
> 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!
>

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" <[email protected]> wrote in message news:[email protected]...
> > 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!
> >
>
>
>

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" <[email protected]> wrote in message news:[email protected]...
>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" <[email protected]> wrote in message news:[email protected]...
>> > 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!
>> >
>>
>>
>>

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" <[email protected]> wrote in message news:[email protected]...
> >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" <[email protected]> wrote in message news:[email protected]...
> >> > 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!
> >> >
> >>
> >>
> >>
>
>
>