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

Linking data in MS Word into Excel 5
Paste not working in Excel 07 1
Excel 2010 not allowing me to paste as formula 8
Excel Issue with "Average" showing in Status Bar 2
Make Paste values default... 0
Keeping Conditional Formats 'Constant' when copy & paste 0
Copy and Paste cells limitation 4
Cut & Paste (from Excel 07 to Outlook) 0

Top