Home |
Search |
Today's Posts |
#1
|
|||
|
|||
trying to "paste special" data; why does worksheet object appear?
Hello,
My problem is that I will select data in one sheet or workbook, copy it, then select "paste special" to paste with a specific format (e.g. keep column widths, values only etc.) into a new sheet; when I try to "paste special" into the new sheet, the data is somehow read as a Worksheet Object, and my choices are Picture, Bitmap etc. How can I fix this? Thanks very much in advance for your advice. Alyssa |
#2
|
|||
|
|||
It sounds like you have two instances of excel open and are trying to paste
between them. If you close one instance and then use File|open to open the other workbook in the first instance, you'll see that normal paste special dialog. alyssa wrote: Hello, My problem is that I will select data in one sheet or workbook, copy it, then select "paste special" to paste with a specific format (e.g. keep column widths, values only etc.) into a new sheet; when I try to "paste special" into the new sheet, the data is somehow read as a Worksheet Object, and my choices are Picture, Bitmap etc. How can I fix this? Thanks very much in advance for your advice. Alyssa -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 chart does not update when worksheet data changes | Charts and Charting in Excel | |||
extract data from worksheet | Excel Worksheet Functions | |||
How do I collect data from an interactive web worksheet and impor. | Excel Discussion (Misc queries) | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Daily Macro to Download Data, Order and paste in order | Excel Worksheet Functions |