Why wont my comments copy from 1 workbook to another??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have tried everything to get the comments and contents of cells from 1
workbook to copy to another. When I use the Paste Special option I do not
get the correct dialogue box to open. (the one that asks if you want to
paste all, formats, comments, etc. with selection check boxes) I get the
Paste Special dialogue box opening that says Paste Special as: Microsoft
Office Excell Worksheet Object, Bitmap, Biff5, 4, 3 etc. What is happening??
How do I fix this problem???
 
Works for me, how are you copying, select the areaq and do edit>copy?

Regards,

Peo Sjoblom
 
I get the Paste Special dialogue box opening that says Paste Special as:Office Excell Worksheet Object, Bitmap, Biff5, 4, 3 etc.

That's what you get when you try to paste between two instances of Excel.
To get the usual PS dialog both workbooks must be open in the same Excel
instance.

--
Jim
|I have tried everything to get the comments and contents of cells from 1
| workbook to copy to another. When I use the Paste Special option I do not
| get the correct dialogue box to open. (the one that asks if you want to
| paste all, formats, comments, etc. with selection check boxes) I get the
| Paste Special dialogue box opening that says Paste Special as: Microsoft
| Office Excell Worksheet Object, Bitmap, Biff5, 4, 3 etc. What is
happening??
| How do I fix this problem???
 
I have tried edit> copy. I have tried right clicking selecting copy and also
using the copy button on the toolbar nothing works!!!
 
Thanks Jim that worked just fine!!!

Thank you so much, wow was I ever getting frustrated!! :)
 
Is there any way to get around the issue of having to be in the same instance
of Excel? I have dual monitors set up and am looking at each worksheet on a
separate monitor which requires that I have 2 instances of Excel running. I
need to see both sheets as I'm copying and pasting and I also need those
comments to paste. Very frustrating.
Peg
 
Back
Top