Won't allow copy/paste or won't copy/paste correctly?

Could be you are opening the two workbooks each in a separate instance of Excel.

Try opening both books in one instance.


Gord Dibben MS Excel MVP

On Mon, 30 Oct 2006 20:20:56 +0530, Sibil71
wrote:


For some reason Excel won't let me copy and paste from one open workbook
to another. I can copy and paste between worksheets in the same book,
but not between different workbooks. I tried going through options &
preferences but didn't see anything that looked suspicious. I use to be
able to copy between books, but all of a sudden can't. Any suggestions??
Thanks so much!