Paste not working correctly in MS Excel '07

  • Thread starter Thread starter DJMarkAnderson
  • Start date Start date
D

DJMarkAnderson

Hi there

When copying data from one worksheet to another, the data comes across, but
I can't get the formatting / formulae etc to copy across too. There are
reduced paste options too in the paste menu. Anyone got any ideas?

Thanks,

M Anderson
 
What are the "reduced paste options"?

Text and Unicode Text only?

Are you copying from one workbook to another?

Might be you have two instances of Excel running with a workbook in each.

These will not communicate with each other.

Close one instance and open both workbooks in the remaining instance.


Gord Dibben MS Excel MVP
 
Hi Gord, thanks for your response.

It is as you state 'Text and Unicode Text' only. It's copying and pasting
from one worksheet to another within the same workbook.

Any more ideas?

Thanks,

Mark
 
Back
Top