Paste Special

G

Guest

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?
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top