Paste Function disabled

  • Thread starter Charmy Roelstraete
  • Start date
C

Charmy Roelstraete

Hi All,
I really need the help of the experts amongst you all!
I have an excel format which we use for reporting to HQ.
But now I cannot paste data in anymore if the original
data was copied from an external Excel workbook.
Any idea?

So If I do copy and Paste in the same workbook the Paste-
function is enabled. If I do copy in Workbook X and I
want to paste it in the excel format for HeadQuarter the
Paste ( and Paste Special ) function is disabled.

I would appreciate your help!!!!!

Thanks,
Charmy
 
J

Jim Rech

I would guess that there is a macro running when you change workbooks to do
the paste that has a side-effect of clearing the clipboard.

To test this, open both workbooks with macros disabled. One way to do this
is to hold the Shift key down as you open them. Another is through the
Security warning dialog if you've set it to warn you about macros.

If you can then do a copy/paste across workbooks you know a macro is likely
the cause of the problem. Then you can find the macro in question.

--
Jim Rech
Excel MVP

| Hi All,
| I really need the help of the experts amongst you all!
| I have an excel format which we use for reporting to HQ.
| But now I cannot paste data in anymore if the original
| data was copied from an external Excel workbook.
| Any idea?
|
| So If I do copy and Paste in the same workbook the Paste-
| function is enabled. If I do copy in Workbook X and I
| want to paste it in the excel format for HeadQuarter the
| Paste ( and Paste Special ) function is disabled.
|
| I would appreciate your help!!!!!
|
| Thanks,
| Charmy
 
Top