I work for a company that has Excel 2007, but frequently receive 2003 files.
For some, when they copy from the 2003 file in email and Paste Special to
blank 2007 worksheet, all the Paste Special options are displayed. For
others, when they go to copy and Paste Special, the new worksheet sees the
copied data as an object (showing only Paste/Paste Link). I know this is
probably due to both 2003 and 2007 workbooks being open, but I don't
understand why some are able to get all of the Paste Special options when
others can't. They're the same type of files and they all have Excel 2007.
How can I make it so they're all able to get all the Paste Special options?