Paste Special and Linking
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).
|