What happened to my special paste dialog box?


G

Guest

i have used special paste before to transfer data from one cell in one
worksheet to a cell formed by 4 merged columns in another worksheet--using
copy-special paste-formula. Works like a charm. Now when i try to use
special paste i get a totally different dialog box with totally different
options. Instead of seeing All/formula/Values/formats....etc i see things
like Bitmap, biff, html, hyperlink.....etc HELP Where are the old options?

caraol49
 
Ad

Advertisements

D

Dave Peterson

You have two copies of excel running.

Close one of the workbooks (and that instance of excel).

Then in the remaining instance, do File|Open to open your other file.

Then try your copy|paste special.
 
Ad

Advertisements


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

Similar Threads

Paste Special Values 2
Paste special for formulas 4
No "Comments" in Paste Special 5
Copy and paste special 2
Paste Special not working 4
Paste Special in Excel 2003 6
Paste special not working 2
Paste Special 1

Top