software

Previously, when I used the function Paste Special a dialog box appeared
prompting for selections such as all, formula, formatting, etc. Suddenly,
when I start a new worksheet, a different dialog box appears prompting for
options for embedding the item I am trying to paste. Obviously an setup
option has changed – can you tell me what’s going on?

My guess is that you have two different instances of excel open--not two
workbooks open in the same instance.

Try closing one of the workbooks (and that instance of excel, too).

Then go to the other workbook's instance of excel and use File|open to open the
second file.

Now try copy, then paste|special.
sdmccabe wrote:
gt;
gt; Previously, when I used the function Paste Special a dialog box appeared
gt; prompting for selections such as all, formula, formatting, etc. Suddenly,
gt; when I start a new worksheet, a different dialog box appears prompting for
gt; options for embedding the item I am trying to paste. Obviously an setup
gt; option has changed – can you tell me what’s going on?

--

Dave Peterson