Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste not working correctly in MS Excel '07
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste not working correctly in MS Excel '07
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 On Mon, 31 Aug 2009 12:05:01 -0700, DJMarkAnderson wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste not working correctly in MS Excel '07
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 "Gord Dibben" wrote: 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 On Mon, 31 Aug 2009 12:05:01 -0700, DJMarkAnderson wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Paste not working correctly in MS Excel '07
We had a similar posting on 13 Aug.
http://tinyurl.com/l6422o Ultimate fix was to run detect and repair. Gord On Mon, 31 Aug 2009 14:30:01 -0700, DJMarkAnderson wrote: 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 "Gord Dibben" wrote: 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 On Mon, 31 Aug 2009 12:05:01 -0700, DJMarkAnderson wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar not working correctly in IE after loading Excel doc in bro | Excel Discussion (Misc queries) | |||
Text to Columns not working correctly with dates in Excel 2007 | Excel Discussion (Misc queries) | |||
excel vlookup not working correctly | Excel Worksheet Functions | |||
Excel 2003 Subtotals not working correctly | Excel Worksheet Functions | |||
Sum function not working correctly in Excel (Skips Cell) | Excel Worksheet Functions |