Paste not working correctly in MS Excel '07

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
 
G

Gord Dibben

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
 
D

DJMarkAnderson

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
 

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

Paste not working in Excel 07 1
Excel 2010 not allowing me to paste as formula 5
Copy paste only working once 2
I want Paste Special (not Paste Link) 2
paste function not working Excel 2007 2
Paste Special in Excel 2003 6
Excel is pasting values, not formulas by default 3
Copy Paste problem 3

Top