No Paste Special feature between two Excel files
Posted on 2012-03-21
When I open two Excel files and try to copy/paste using the Paste Special as values from file A to file B I lose the Paste Special features. To get around that issue I close the file B, then open through the file A then I can get the paste special options showing again to do my pasting as values, formulas etc. This is not how Excel should be supporting copy paste between two files and I should be able to use the clipboard between any number of Excel files open. Needless to say that in the middle of the crunch this really gets annoying. To fix this issue I went to Task Manager and made sure that there was not more than one Excel.exe session is showing and that was not the case. What would be the recommended solution to this problem? I use Excel 2010.