Are you sure you're trying to open both workbooks in the same instance of
excel--not just the same version.

If you open excel, then file|open your first workbook, then File|new, you really
get that "funny" paste special dialog?



ajkim001 wrote:

Good Point... But I am opening the file in Excel 2003 and from there
clicking File/New, so it should be opening the new sheet in 2003.

"MarkN" wrote:

I think this is happening because you are opening two versions of Excel. If
you open one of the Excel files and then use File, Open and navigate to the
other, you should then see the standard Paste Special box.
--
Hope this helps,
MarkN


"ajkim001" wrote:

Trying to do a copy and paste special into a new sheet that is linked to
another (contains formulas). However, I get a different dialog box. Instead
of the default (paste special) window with radio buttons where I can select
the the type of paste and operation, and there are skip blanks, transpose,
and paste link options... I
get a window (w/ same name "paste special" title) that says As: with a list
of
options, a display as icon box, and a results section on the bottom saying
"Inserts the contents of the clipboard into your document..." What is this
different Paste Special box and how can I get the default/original one? I am
using Office 2003 (occured in 2000 also, but was hoping an upgrade would fix
the issue).

--

Dave Peterson