I'm using Excell 2007 - but download data from an external source that's in
Excel 2003. In the past, before moving to Excel 07, I could manipulate the
data, cut and paste into other documents without having any difficulties.
However, now that we switched to 2007, I can manipulate the data, but if I
try to do a "Paste Special", when coping parts of the data to new worksheet,
I get a dialog box that states that the data is a "Microsoft Office Excel
Worksheet Object" and then gives me several options to select from. Even if
I pick Microsoft Excel 8.0 Format, it still won't allow me to copy and do a
paste special. If I try to do a Paste Special in another tab in the same
document, the Paste Special works fine. Every once in a while, I must hit
the right combination of what to do because it suddenly allows me to do a
copy and paste special from worksheet to worksheet like it should be done. I
don't know if it's the way I save the files, or what. I've tried just about
everything that I can think of 1) saving the file as a XLSX file, saving it
as XLS.... I'm just about at my wits end trying to manipulate the files.
Nothing seems to work. I'm too lazy to have to modify the column widths
everytime I need to copy the data..
If anyone has any input on what is occurring and if there's anything I can
do about it, I would be ever so grateful for any suggestions!



--
Lady