Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I'm using Windows XP SP3 and am having some annoying problems with the "Paste Special" function in Excel 2007. Usually when I copy something from Excel to Excel and use Paste Special I get this dialog:

enter image description here

Now however I'm always getting this other strange dialog:

enter image description here

I suspect it's not solely an Office problem because I reinstalled it and the problem still exists.

Any ideas?

share|improve this question

1 Answer 1

up vote 0 down vote accepted

This happens if you open each Excel file in a separate instance of Excel, i.e., if you start Excel as a new process for each file. The easiest solution is to use the "file" (logo)/"open" option inside Excel.

share|improve this answer
1  
I have problems even if I copy from same sheet not just another excel file. –  Primoz Sep 21 '10 at 6:58

protected by Community Mar 22 '12 at 14:47

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.