Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not able to Paste into other cells
I have a user who is trying to copy & paste data from multiple cells on a
worksheet, to another area on the worksheet. When he tries to paste, it pastes totally different numbers than the previous cells. I was able to paste the correct data but in Word. I don't know if it makes a difference, but the user was trying to copy cells of data pasted into an Outlook email into an Excel worksheet. Is it possible that the data wouldn't paste into Excel correctly because Outlook uses Word as its editor?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Not able to Paste into other cells
Brandon --
It occurs to me that, when you're pasting, you're pasting the cell formulas. Those formulas pick up new (or non-existent) data in the new worksheet. The reason why it would work in Word would be because it's pasting the cell results instead. To test this idea, use EditPasteSpecial to just paste the cell values and see if you get the right results. HTH "Brandon" wrote: I have a user who is trying to copy & paste data from multiple cells on a worksheet, to another area on the worksheet. When he tries to paste, it pastes totally different numbers than the previous cells. I was able to paste the correct data but in Word. I don't know if it makes a difference, but the user was trying to copy cells of data pasted into an Outlook email into an Excel worksheet. Is it possible that the data wouldn't paste into Excel correctly because Outlook uses Word as its editor?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to paste data into multiple cells in Excel | New Users to Excel | |||
Paste special treats cells as a picture | Excel Discussion (Misc queries) | |||
copy and paste between cells that have data | Excel Worksheet Functions | |||
Paste into Visible Cells Only | Excel Discussion (Misc queries) | |||
Not able to Paste cells | Excel Discussion (Misc queries) |