copy cells become blank

M

MasterDragon

I have a problem that when I copy some cells from a 97-03 workbook to another
07 workbook, the excel consider what I copied as an object. Besides, the
pasted cells are ALL BLANK, no values inside. But when I choose to copy TEXT
or UNICODE TEXT, the problem solves. What shall I do to make sure excel
recognize them as cells instead of objects?
 
G

Gord Dibben

To have the cells recognized as cells you must have both workbooks open in a
single instance of Excel.

You can open 97-03 workbooks in a session of Excel 2007 along with the 2007
workbook.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed the same Excel multiple times 0
Word macro that can call cells out of Excel for a find and replace 0
Excel does not accept text format! 0
Linking data in MS Word into Excel 5
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Pasting a cell into bookmarked table from excel vba 1
Visio shape text disappears upon copy paste 1
Move Chart with Text 0

Top