What happened to my special paste dialog box?



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?




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.


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