Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
copy cells become blank
0 views
Skip to first unread message
MasterDragon
Jan 2, 2010, 12:28:01 AM1/2/10
to
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?
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?
Gord Dibben
Jan 3, 2010, 12:37:06 PM1/3/10
to
To have the cells recognized as cells you must have both workbooks open in a
single instance of Excel.
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
0 new messages